The
first method worked great. Thank you Fred.
Eric
__20060125_______________________This posting was submitted with HTML in it___-----Original Message-----**
From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED]On Behalf Of Grooms, Frederick W
Sent: Thursday, October 05, 2006 10:37 AM
To: [email protected]
Subject: Re: Which fields are indexed?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
__20060125_______________________This posting was submitted with HTML in it___
