03-17-2009 4:23 AM
Dear Experts,
For performance improvement , I created one Non-unique secondary index on table MBEW on the fields
MANDT , MATNR , BWKEY , LFMON and LFGJA . I saved , activated and then transported it to our Quality server .
But if I open that index either through SE 11 or SE 14 , it shows that
Index does not exist in database system ORACLE
Why does it do not exist in database even after save , activate and even transport ( I can see that index in Quality Server with message Index does not exist in database system ORACLE ).
Any suggestions please , Should I necessarily keep MANDT field in that index ?
thanks...........
03-17-2009 4:52 AM
Hi frnd,
After cretaing the index have u adjusted the table using SE14.
03-17-2009 4:37 AM
Hi frnd,
While creating non-unique key secondary index, u have to choose "Index on all database system or For all selected database systems".
03-17-2009 4:40 AM
03-17-2009 4:52 AM
Hi frnd,
After cretaing the index have u adjusted the table using SE14.
03-17-2009 5:04 AM
Hi Nivetha,
I did not do that step. I did not do it for one more table MBEWH ... But then also that index in MBEWH exist in database..........
Thanks
03-17-2009 6:32 AM
issue resolved..........that index has to be adjusted in SE 14................tahnks for your valuable reply.....