topic Re: Index does not exist in database system ORACLE in Application Development and Automation Discussions

Index does not exist in database system ORACLE

Former Member — Tue, 17 Mar 2009 04:23:42 GMT

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

Re: Index does not exist in database system ORACLE

Former Member — Tue, 17 Mar 2009 04:37:45 GMT

Hi frnd,

While creating non-unique key secondary index, u have to choose "Index on all database system or For all selected database systems".

Re: Index does not exist in database system ORACLE

Former Member — Tue, 17 Mar 2009 04:40:25 GMT

Hi nivetha,

This is the index on all database systems

Thanks.....

Re: Index does not exist in database system ORACLE

Former Member — Tue, 17 Mar 2009 04:52:25 GMT

Hi frnd,

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

Re: Index does not exist in database system ORACLE

Former Member — Tue, 17 Mar 2009 05:04:26 GMT

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

Re: Index does not exist in database system ORACLE

Former Member — Tue, 17 Mar 2009 06:32:14 GMT

issue resolved..........that index has to be adjusted in SE 14................tahnks for your valuable reply.....