Monday, January 30, 2012

DRG-10700: preference does not exist: CTXSYS.DEFAULT_WORDLIST

After data migration from 9i to 11g, was facing DEFAULT_WORDLIST text index creation issue.  After some research, it appeared that default_worldlist preference needs to be configured on ctxsys same as it was on old database.

Problem:
ERROR at line 1:
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
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366

SOLUTION:
Login as CTXSYS:
BEGIN
CTX_DDL.create_preference('CTXSYS.DEFAULT_WORDLIST', 'BASIC_WORDLIST');
END;

update dr$parameter
set par_value = 'CTXSYS.EMPTY_STOPLIST'
where par_value = 'CTXSYS.DEFAULT_STOPLIST';

BEGIN
CTX_DDL.create_preference('CTXSYS.DEFAULT_LEXER', 'BASIC_LEXER');
END;

No comments: