My Oracle Support Banner

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

Last updated on MAY 22, 2020

Applies to:

Oracle WebCenter Content - Version 10.0 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'},,)


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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