Error in Creating Secondary Table Index

[Former Member]

Hi,

I have created a secondary table index in a custom table. It was successful in DEV, no warning messages. however, when i transported it to the test environment, there was a warning message:

Index does not exist in database system ORACLE

The status is still active though. Is this an error which means the secondary index will not work properly?

Please let me know.

Thank you.

[HermannGahm]

Hi,

check in SE14 - TABNAME - edit - indexes - your index

whether it exists on the database or not. If it does not exit

create the index in the database.

Kind regards,

Hermann

[ravi_lanjewar]

Hi,

You can also activate index using missing index with transaction st04. Which you have created.

[Former Member]

Hi,

You have to go se04 transaction.here you can activate the missing index.in left side frame

Index>Indexanalysis.You can activate.and also plz check your ztable>index is present.

Rgds,

Soosairaj.A

[Former Member]

Hi,

Can be the strange answer but please check whether you have transported your customized table first or not.

I may be wrong, plz check.