Indexing Aborted. Unable To Execute Callable Query 'CoracleTextExchangeShadowIndex' (Doc ID 2167699.1)

Last updated on APRIL 27, 2018

Applies to:

Symptoms

A fast index rebuild aborted just prior to completion.  The following error was found in the Content Server online logs (Administration -> Log Files -> Content Server Logs).

Error<DATETIME> Indexing aborted. Unable to execute callable query 'CoracleTextExchangeShadowIndex'. ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvrio.alter_swap_shadow
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-20000: Oracle Text error:
DRG-13509: error while swapping shadow index
User-Defined Exception
DRG-50857: oracle error in drvxtab.swap_index_temp_tables
ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 1737
ORA-06512: at line 1
java.sql.SQLException: ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvrio.alter_swap_shadow
ORA-29858: error occurred in the execution of ODCIINDEXALTER routine
ORA-20000: Oracle Text error:
DRG-13509: error while swapping shadow index
User-Defined Exception
DRG-50857: oracle error in drvxtab.swap_index_temp_tables
ORA-14097: column type or size mismatch in ALTER TABLE EXCHANGE PARTITION
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 1737
ORA-06512: at line 1. [ Details ]

Changes

 The solution in the following KM note was executed to resolve another issue.

CTX_DDL.RECREATE_INDEX_ONLINE Raises DRG-50857 ORA-14097 DRG-13509 (Doc ID 1903909.1)

Cause

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