<div>
Since you are going to recreate it I assume you have the syntax.<br />
<br />
What type of index is this? &nbsp;
</div>


Since you are going to recreate it I assume you have the syntax.

What type of index is this?  

<div>
I would not just drop a domain index on 10g. &nbsp;There is a known bug that can really get you (I know, I 'discovered' it).<br />
<br />
I had an Oracle Text Index and a Function Based Index (FBI) in the same database. &nbsp;Both of these are considered 'Domain' indexes &nbsp;When I dropped the FBI to rebuild it, it corrupted the Text index.<br />
<br />
If took Oracle a long time to figure out this one and it was a simple low level table update to get it working again.<br />
<br />
It's not a public bug but here's the number:<br />
5402174: DROP COLUMN COULD CHANGE FUNCTIONAL DOMAIN INDEX COLUMN NAME
</div>


I would not just drop a domain index on 10g.  There is a known bug that can really get you (I know, I 'discovered' it).

I had an Oracle Text Index and a Function Based Index (FBI) in the same database.  Both of these are considered 'Domain' indexes  When I dropped the FBI to rebuild it, it corrupted the Text index.

If took Oracle a long time to figure out this one and it was a simple low level table update to get it working again.

It's not a public bug but here's the number:
5402174: DROP COLUMN COULD CHANGE FUNCTIONAL DOMAIN INDEX COLUMN NAME

<div>
<div class="content wysiwyg-content">
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<br />
<br />
Alter index customer_tix rebuild;<br />
<br />
but get the error <br />
<br />
&quot;Cannot issue DDL on a domain index marked as LOADING&quot;<br />
<br />
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.<br />
<br />
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.<br />
<br />
Many thanks,<br />
<br />
Jon
</div>
</div>


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.

Many thanks,

Jon

Drop and re-create a domain index

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.