DRG-10700: preference does not exist

Recently I got this error on my db, while setting up Oracle Text


Here is how it was resolved.

Login as CTXSYS ( Reset the password, if you dont know the password)

Run the following block

Exec CTX_DDL.create_preference('CTXSYS.DEFAULT_WORDLIST', 'BASIC_WORDLIST');

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


Exec CTX_DDL.create_preference('CTXSYS.DEFAULT_LEXER', 'BASIC_LEXER');

COMMIT;