Hi, If the index does not exist in the DB, remedy will error when you try to remoce the "orphan" index in the Admin tool.
As I mentioned earlier, schema_index is where remedy keeps track of indexes on the table. You have to delete the record that has the info about the orphan index. Atul > ----- Original Message ----- > From: "Vyom Labs - ITSM Support" <[EMAIL PROTECTED]> > To: arslist@ARSLIST.ORG > Subject: Re: Corrupted Index on CHG:TSK > Date: Fri, 27 Apr 2007 19:40:27 +0530 > > > Hi, > First of all you have to check all indexes on your 'CHG:TSK' Form and find > out > which index is missing in database.After that, create missing index manually > by querying the database.Then add/remove index from the Admin console.Save > the > changes.This will help you to resolve the ora error for index. > > Thanks, > Sunil > > -- [EMAIL PROTECTED] > > www.vyomlabs.com > Consulting | Oursourcing | Training || BMC Remedy BSM | ITIL | IT Governance > > > Atul Vohra wrote: > > ** > > 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: arslist@ARSLIST.ORG > > 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.6 > > Oracle 9.2 > > > > Den > > > > Husky Energy Inc. > > 707-8th Avenue SW > > Calgary, Alberta CANADA > > T2P 3G7 > > Phone : 1-403-298-7244 > > Fax : 1-403-298-6476 > > > > __20060125_______________________This posting was submitted with > > HTML in it___ __20060125_______________________This posting was > > submitted with HTML in it___ > > _______________________________________________________________________________ > UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the > Answers Are" > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
