Drop and re-create a domain index
Posted on 2011-03-11
I have a domain index in a 10g database that seems to be corrupt. I have triued to rebuild the index using the following syntax
Alter index customer_tix rebuild;
but get the error
"Cannot issue DDL on a domain index marked as LOADING"
I beileve that I need to drop and recreate the index but am nervous as this is in a production Db that is part of an ERP.
How can I work out what the exact syntax is that originally created the index? I have contacted the ERP vendor and they are no help.