Encountered ORA-29858, ORA-00942, ORA-06512, ORA-06510 while rebuilding a CTXCAT index
(Doc ID 1359828.1)
Last updated on MARCH 12, 2020
Applies to:
Oracle Text - Version 10.2.0.4 to 12.2.0.1 [Release 10.2 to 12.2]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
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
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
from user_indexes where index_name = 'TEST_IDX';
INDEX_NAME ITYP_NAME STATUS DOMIDX_STATU DOMIDX
---------- ---------- -------- ------------ ------
TEST_IDX CTXCAT VALID VALID FAILED
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |