I seem to recall a bug a while back where Oracle would drop the indexes on Remedy forms (on import of the form I think). This would cause Remedy to think there were indexes on forms (based on its SCHEMA_INDEX table), when in reality, there weren't any as far as Oracle was concerned.
I'm not sure where the issues stands now, and at the time I think Oracle and Remedy were in a finger pointing game as to what was actually the root cause. If I recall the versions were ARS 6.3 and Oracle 9.2. Anyway, its something to keep in mind.
Thad
"Argue for your limitations, and sure enough, they're yours."-- Richard Bach
| "Eric Cleereman (IT)"
<[EMAIL PROTECTED]>
Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 10/05/2006 07:42 AM
|
|
**
The first method worked great. Thank you Fred.
Eric
-----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___
__20060125_______________________This posting was submitted
with HTML in it___
***IMPORTANT NOTICE: This communication, including any attachment, contains information that may be confidential or privileged, and is intended solely for the entity or individual to whom it is addressed. If you are not the intended recipient, you should delete this message and are hereby notified that any disclosure, copying, or distribution of this message is strictly prohibited. Nothing in this email, including any attachment, is intended to be a legally binding signature.***
