Text Index failing to create on first attempt
Hi,
On our Production 11gR2 DB single instance we drop and re-create text indexes on daily basis through a script. Lately, on some odd days the text index creation fails with below errors. Nonetheless, on second attempt the index gets created fine.
CREATING VAC_SEARCH_IDX at Sun Sep 22 00:46:07 2013
DBD::Oracle::db do failed: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10502: index VAC_SEARCH_IDX does not exist
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366 (DBD ERROR: OCIStmtExecute)
[for Statement "CREATE INDEX VAC_SEARCH_IDX ON VAC_SEARCH(composite_vacancy) INDEXTYPE IS ctxsys.context
On our Production 11gR2 DB single instance we drop and re-create text indexes on daily basis through a script. Lately, on some odd days the text index creation fails with below errors. Nonetheless, on second attempt the index gets created fine.
CREATING VAC_SEARCH_IDX at Sun Sep 22 00:46:07 2013
DBD::Oracle::db do failed: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10502: index VAC_SEARCH_IDX does not exist
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366 (DBD ERROR: OCIStmtExecute)
[for Statement "CREATE INDEX VAC_SEARCH_IDX ON VAC_SEARCH(composite_vacancy) INDEXTYPE IS ctxsys.context
0