Error on Collection Rebuild Using DATABASE.FULLTEXT: ORA-29855: error occurred in the execution of ODCINDEXCREATE

(Doc ID 1417994.1)

Last updated on MAY 01, 2017

Applies to:

Oracle WebCenter Content - Version 10.1.3.3.3 to 10.1.3.6.0 [Release 10gR3]
Information in this document applies to any platform.
***Checked for relevance on 24-Jul-2013***

Goal

When performing a collection rebuild, the following error occurs: 

 

Indexing aborted at 1/30/12. Unable to delete collection directories. Indexer could not create table or index: IdcColl2. Unable to execute SQL statement 'CREATE INDEX FT_IdcColl2 ON IdcColl2 (dDocFullText) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS(DATASTORE CTXSYS.DEFAULT_DATASTORE FILTER CTXSYS.AUTO_FILTER FORMAT COLUMN DFULLTEXTFORMAT CHARSET COLUMN DFULLTEXTCHARSET LEXER OCS_IDCCOLL@_LEXER SYNC (ON COMMIT)")" ORA-29855: error occurred in the execution of ODCINDEXCREATE routine ORA-20000: Oracle Text error:

ORA-06512: at "CTXSYS.DRUE, line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364



Solution

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