Index deletion

[Former Member]

Hello Expert,

We are facing an issue with the secondry index in MARI table. We have created an additional index for our requirement.

But we are noticing that both the secondry index one provided by SAP and one created by us are getting deleted at the database level again and again. We have recreated them 3 times and they got deleted automatically from the database. We dont find any log also for the index getting deleted. Please can you assist for knowing the possible root causes for this issue and how to fix it.

Regards, Kapil.

[Former Member]

What database is this? I am pretty sure that there's nothing like this in SQL 2000, 05, and 08.

[Former Member]

Kevin We are having Oracle database for our SAP.

[Former Member]

I would try posting this in the Oracle part of this forum instead, they may be able to help you more.