Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> ORA-29861 : domain index is marked LOADING/FAILED/UNUSABLE

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

From: Marc Welk <Marc.Welk_at_brave.de>
Date: Mon, 24 May 2004 19:47:52 +0200
Message-ID: <c8tcg8$vii$1@news.brave.de> 





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
Received on Mon May 24 2004 - 12:47:52 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US