Index Optimization Routine Fails While Optimizing OracleTextSearch (Doc ID 1101757.1)

Last updated on SEPTEMBER 21, 2016

Applies to:

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

Symptoms

Index Optimization fails when initiated from UCM server.


Error:

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'},,)

Cause

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