DMU (Data Migration Ass't for Unicode) gives ora-29855, drg-10700
During the latter part of a db character set conversion I'm getting CTXSYS index creation errors for all of my CTXSYS indexes:
08.14:55:24:013;V006;F;05000 SQL text is
CREATE INDEX "INTERNART"."ARTFORM_DESCR_IDX" ON "INTERNART"."ARTFORM" ("ARTDESCR")
INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('lexer english_lexer stoplist ctxsys.default_stoplist');
08.14:55:24:015;V006;F;05001 Exception call stack is
java.sql.SQLException: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: english_lexer
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366
Can someone please give me some guidance on how to fix this?
08.14:55:24:013;V006;F;05000 SQL text is
CREATE INDEX "INTERNART"."ARTFORM_DESCR_IDX" ON "INTERNART"."ARTFORM" ("ARTDESCR")
INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('lexer english_lexer stoplist ctxsys.default_stoplist');
08.14:55:24:015;V006;F;05001 Exception call stack is
java.sql.SQLException: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-10700: preference does not exist: english_lexer
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366
Can someone please give me some guidance on how to fix this?
0