My Oracle Support Banner

Text index is failing with DRG-50857 and ORA-00922 error (Doc ID 2356033.1)

Last updated on FEBRUARY 07, 2018

Applies to:

Oracle Text - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.0.2 version, Creating/Maintaining context indexes

Creating an Oracle Text index is failing with DRG-50857 error

CREATE INDEX <owner>.<index name> ON <owner>.<table name>
(<column name>) INDEXTYPE IS CTXSYS.CONTEXT PARAMETERS
('wordlist <owner>.<wordlist preference name>
storage <owner>.<storage preference name>
stoplist <owner>.<stoplist name>
lexer <owner>.<lexer preference name> memory 5242880');
  2 3 4 5 6 CREATE INDEX .......
*
ERROR at line 1:
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvxtab.create_index_tables
ORA-00922: missing or invalid option
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366

 

ERROR
-----------------------
DRG-50857

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.