Re: ORA-29861 : domain index is marked LOADING/FAILED/UNUSABLE

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Mon, 24 May 2004 21:21:26 +0200
Message-ID: <c8tho4$n5v$1@news3.tilbu1.nb.home.nl>

Marc Welk wrote:

> Hi,
>
> while inserting/updating data in a table error ORA-29861 appears. I
> searched the web and found the error in the Oracle-FAQ:
> http://otn.oracle.com/products/text/x/faqs/imt_faq.html#30
>
> But none of the described facts fits to my problem. The STATUS of all
> Entries in USER_INDEXES for my table are 'VALID', DOMIDX_STATUS and
> DOMIDX_OPSTATUS are emty.
>
> Environment: Oracle 8i Enterprise 8.1.6.1.0
>
> Has anyone an idea?
>
> Marc

It's a Oracle Context (I think it was called that in 8.1.6) index. Run the update job in the documented way (tongue in cheek)

-- 

Regards,
Frank van Bortel

Received on Mon May 24 2004 - 14:21:26 CDT