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"