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 laterInformation in this document applies to any platform.
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
ORA-06512: at "CTXSYS.DRUE, line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364
Solution
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
Goal |
Solution |