Hi Den,
Check the schema_index table to see what index names should exist for the
specific schemaId. Then add them by hand.
The schemaId is found in th arschema table.
To get the correct SQL syntax, you can allway do something like this:
- Turn on SQL logging
- Create a similar index in a form through AR Admin
- Save
- Remove the index through AR Admin
- Save
You now have SQL the syntax for adding/removing indexes in your database.
Best Regards - Misi, RRR AB, http://www.rrr.se/sv/
> 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
>
>
> _______________________________________________________________________________
> 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"
