My Oracle Support Banner

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, 2023

Applies to:

Oracle WebCenter Content - Version 10.0 and later
Information in this document applies to any platform.


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


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.