Customer Secondary Indexes - how to list

[Former Member]

Hi,

can anybody help me on this question?

I' m looking for a simple way to find out which and when customer indexes were created just with SAP means.

Best regards,

Frank

[Former Member]

If you know the table name, look at the indexes in SE11 trx. Any index starting with a Z or Y is customer created.

SAP indexes have a different name range usually 001, 002 etc.

Hope this helps.

Srini

[Former Member]

Hi Srini,

many thanks for your help but unfortunately your answer does not meet the problem.

I don't know the table so I have to find out in general which customer indexes have been created in a certain range of time.

Perhaps you have a solution on my specific problem?

Best regards

Frank

[Former Member]

Hi,

As this is an oracle forum I'll give you an oracle answer:

SELECT object_name, created

FROM DBA_OBJECTS

WHERE object_type = 'INDEX'

AND owner = <schema>

AND object_name like "Z%"

AND created BETWEEN <date> AND <date>;