Index Optimization Routine Fails While Optimizing OracleTextSearch

(Doc ID 1101757.1)

Last updated on DECEMBER 21, 2017

Applies to:

Oracle WebCenter Content - Version and later
Information in this document applies to any platform.
***Checked for relevance on 15-May-2013***


Index Optimization fails when initiated from UCM server.


After disabling the auto update cycle, we started index optimization but it failed at 11:09PM.

!csDbUnableToExecuteCallableQuery,CoracleTextOptimizeIndex!$ORA-20000: Oracle Text error: DRG-50857: oracle error in dresoflush ORA-01461: can bind a LONG value only for insert into a LONG column ORA-06512: at "CTXSYS.DRUE"\, line 160 ORA-06512: at "CTXSYS.CTX_DDL"\, line 740 ORA-06512: at line 1 ({ts '2010-05-04 23:09:41.277'},,)


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