Re: Creating a ctxsys.context Index on a CLOB column

I ran this again as user ctxsys and the preference were created successfully.

> 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

Now, this is the error I am getting...

SQL> 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:
ORA-06508: PL/SQL: could not find program unit being called
ORA-06512: at "CTXSYS.DRUE", line 122
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 34
ORA-06512: at line 1

Thanks,
David Received on Tue Mar 26 2002 - 04:42:20 CET