Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: ORA-29861 : domain index is marked LOADING/FAILED/UNUSABLE
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 BortelReceived on Mon May 24 2004 - 14:21:26 CDT
![]() |
![]() |