Archived discussions are read-only. Learn more about SAP Q&A

Index does not exist in database system ORACLE

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...........

replied

Hi frnd,

After cretaing the index have u adjusted the table using SE14.

2 View this answer in context
Not what you were looking for? View more on this topic or Ask a question