Creating a ctxsys.context Index on a CLOB column

Hello,

I am having a problem creating an index of type ctxsys.context on a CLOB column.

The error is that the default lexer does not exist, however it is installed.

If anyone knows how to solve this problem I would greatly appreciate it.

Below is the error I get when trying to create the index, then I list a transcript from trying to fix this problem (which did not work).

Thanks,
David

This is the error I get...

    ORACLE> create index text_Idx on dataset(text) indextype is ctxsys.context;

    create index text_Idx on dataset(text) indextype is ctxsys.context;

*

    ERROR at line 1:
    ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine

    ORA-20000: ConText error:
    DRG-10700: preference does not exist: CTXSYS.DEFAULT_LEXER
    ORA-06512: at "CTXSYS.DRUE", line 122
    ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34
    ORA-06512: at line 1

This is a transcript of a supposed fix, notice that all default preferences exist, contrary to the above error. It was run as sys.

    ORACLE> _at_$ORACLE_HOME/ctx/admin/defaults/drdefus.sql     Creating lexer preference...
    begin
*

    ERROR at line 1:

    ORA-20000: ConText error:
    DRG-10701: preference SYS.DEFAULT_LEXER already exists
    ORA-06512: at "CTXSYS.DRUE", line 122
    ORA-06512: at "CTXSYS.CTX_DDL", line 55
    ORA-06512: at line 2

    Creating wordlist preference...
    begin
*

    ERROR at line 1:

    ORA-20000: ConText error:
    DRG-10701: preference SYS.DEFAULT_WORDLIST already exists
    ORA-06512: at "CTXSYS.DRUE", line 122
    ORA-06512: at "CTXSYS.CTX_DDL", line 55
    ORA-06512: at line 2

    Creating stoplist...
    begin
*

    ERROR at line 1:

    ORA-20000: ConText error:
    DRG-12500: stoplist DEFAULT_STOPLIST already exists
    ORA-06512: at "CTXSYS.DRUE", line 122
    ORA-06512: at "CTXSYS.CTX_DDL", line 659
    ORA-06512: at line 2