WebCenter Content Search Index Auto Update or Rebuild Generates Error: "DRG-10700: PREFERENCE DOES NOT EXIST: CTXSYS.DEFAULT_WORDLIST"

(Doc ID 972396.1)

Last updated on APRIL 20, 2018

Applies to:

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


At the onset of Indexer update scheduled transaction (runs approximately every 5 minutes) OR a forced index rebuild via the Repository Manager Admin Applet the Oracle Database reports the below error to Content Server:

Indexing aborted. Unable to delete collection directories. Cannot create table or index 'IdcText1' Unable to execute SQL statement 'CREATE INDEX FT_IdcText1 ON IdcText1 (otsMeta) INDEXTYPE IS CTXSYS.CONTEXT Filter By dCreateDate,dInDate,dOutDate PARAMETERS('DATASTORE IdcStore_ots1 LEXER IdcLexer_ots1
SECTION GROUP section_group_ots1 MEMORY 20M
SYNC(MANUAL) ')'. ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: CTXSYS.DEFAULT_WORDLIST
ORA-06512: at "CTXSYS.DRUE", line 160


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