Encountered ORA-29858, ORA-00942, ORA-06512, ORA-06510 while rebuilding a CTXCAT index (Doc ID 1359828.1)

Last updated on MARCH 04, 2013

Applies to:

Oracle Text - Version 10.2.0.4 and later
Information in this document applies to any platform.
***Checked for relevance on 05-Mar-2013***

Symptoms

Rebuilding a Text index failed with errors.

SQL> alter index TEST_IDX rebuild online;
alter index TEST_IDX rebuild online
*
ERROR at line 1:
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-00942: table or view does not exist
ORA-06512: at "CTXSYS.CATINDEXMETHODS", line 186
ORA-06510: PL/SQL: unhandled user-defined exception


This caused subsequent operations on the base table to fail.

SQL> insert into test values (2,'the cat sat on the mat');
insert into test values (2,'the cat sat on the mat')
*
ERROR at line 1:
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE


The Text index has the status of FAILED, and the index type is CTXCAT.

SQL> select index_name, ityp_name, status, domidx_status, domidx_opstatus
     from user_indexes where index_name = 'TEST_IDX';

INDEX_NAME ITYP_NAME  STATUS   DOMIDX_STATU DOMIDX
---------- ---------- -------- ------------ ------
TEST_IDX   CTXCAT     VALID    VALID        FAILED



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms