Hi, We faced similar situation in which the DBA actually dropped the index on the T table while remedy was showing the index.
There is a table called schemaindex (not sure of the exact name) that keeps the index per table info for remedy. I actually deleted that index record from this table (so now it matched the actual indexes on the T table). Atul ----- Original Message ----- From: "Den Fong" To: [email protected] Subject: Corrupted Index on CHG:TSK Date: Wed, 25 Apr 2007 13:39:00 -0600 ** I cannot add/remove index on my CHG:TSK form. It gives me an ora error that the index does not exist. I took a look at the DB and the only index on the T table is on C1. Any ideas on how I can get this resolved, I'm thinking I create the index on the T table myself, but not sure how the naming would follow for the index. ITMS 5.6Oracle 9.2 Den Husky Energy Inc. 707-8th Avenue SW Calgary, Alberta CANADA T2P 3G7 Phone : 1-403-298-7244Fax : 1-403-298-6476 __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
