Text index is failing with DRG-50857 and ORA-00922 error
(Doc ID 2356033.1)
Last updated on SEPTEMBER 11, 2023
Applies to:
Oracle Text - Version 12.1.0.2 and laterInformation 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! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |