Re: Domain index in LOADING status and table cannot be updated

You can issue a drop index <index name> force. Then rebuild the index after you have identified the fix for the errors which are showing up in dr$index_errors.

ishambat_at_aol.com (Ilya Shambat) wrote in message news:<d02408fc.0206030750.1dc69af3_at_posting.google.com>...
> Hello,
>
> I'm having a very strange problem. Populating a domain index on a CLOB
> field in CASETEXT table using Java routines was generating millions of
> errors, which were being placed in dr$index_errors table. The
> administrator stopped the Java routines, after which the
> dr$index_errors table was no longer being populated. However, the
> domain index is marked with the status INPROGRESS, or LOADING, and
> updates against the CASETEXT table fail. The application is not
> functioning for this reason. When I run "drop index INDEX_CASETEXT" I
> get error message ORA-29868: cannot issue DLL on domain index marked
> as LOADING." When I run "alter index INDEX_CASETEXT disable" or "alter
> index INDEX_CASETEXT unusable" I get messages telling me that these
> are invalid options. I checked the ALL_TRIGGERS table and did not find
> any triggers that were firing against CASETEXT table. How can I solve
> this problem? Should I truncate the CASETEXT table or is there
> anything I can do to get the index out of the LOADING status?
>
> Any help on this would be greatly appreciated.
>
> Regards,
>
> Ilya.
Received on Tue Jun 04 2002 - 05:40:14 CEST