CREATE INDEX of CTXCAT Indextype Fails with ORA-29855: Error Occurred In The Execution Of ODCIINDEXCREATE Routine (Doc ID 2670823.1)

Last updated on JULY 20, 2024

Applies to:

Symptoms

CREATE INDEX <index name> ON <owner>.<table>(<column>)
INDEXTYPE IS CTXSYS.CTXCAT
NOPARALLEL

fails with the following error stack:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drixmd.PurgeKGL
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drdmlpo
ORA-06502: PL/SQL: numeric or value error: character to number conversion error
ORA-06512: at "CTXSYS.DRIXMD", line 283
ORA-00942: table or view does not exist
ORA-06512: at "CTXSYS.DRIXMD", line 248
ORA-06512: at "CTXSYS.DRVXMD", line 36
ORA-06512: at li
ORA-30576: ConText Option dictionary loading error
ORA-06510: PL/SQL: unhandled user-defined exception
ORA-06512: at "CTXSYS.DRICON", line 677
ORA-06510: PL/SQL: unhandled user-defined exce
DRG-50610: internal error: kglpurge []
DRG-50857: oracle error in dricon.get_data_type
ORA-00942: table or view does not exist
ORA-06512: at "CTXSYS.DRUE", line 186
ORA-06512: at "CTXSYS.CATINDEXMETHODS", line 102
29855. 00000 - "error occurred in the execution of ODCIINDEXCREATE routine"
*Cause: Failed to successfully execute the ODCIIndexCreate routine.
*Action: Check to see if the routine has been coded correctly.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.