You can do a query in the db of the SCHEMA_INDEX
table. It contains the user defined indexes (so remember to add the C1
column index).
Alternate method: Query the USER_INDEXES view of
Oracle where TABLE_NAME like 'T%' and INDEX_NAME like 'IT%' (You may need
to add TABLE_OWNER depending on your db setup)
Fred
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Eric Cleereman (IT)
Sent: Thursday, October 05, 2006 9:02 AM
To: [email protected]
Subject: Which fields are indexed?
Hi All,
We're running ARS 6.3, Oracle 9. Does anyone know of an easy way to output a list of all indexes on all forms to a CSV file?
Eric Cleereman
