Index created on /BI0/PPERSON is not reflecting in Oracle Database

[Former Member]

Hi Experts,

I created a secondary index with name Z01 for /BI0/PPERSON through SE11. After activating I got a warning message "Index does not exist in database system ORACLE" and index is not created in Oracle. Any ideas on this.

Thanks & Regards ::

Balaji T

[dennis_scoville4 · Accepted solution]

There are times, unfortunately, when creating an index on an SAP table, whether it's BI or R3/ECC, where the index doesn't get created in Oracle. In those cases, you will have to have your Basis team member that has Oracle DBA responsibly create the index at the Oracle-level.

[Former Member · Accepted solution]

Thank you Dennis. I got it created in Oracle with the help of our DBA.

Thanks & Regards ::

Balaji T