Database Software

When we setup an of the shelf solution the schena requires Oracle Text, it's supplied with a script to do that. We give the user the CTXAPP role and run it but we got the following Error message saying;

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: english_lexer
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 204
ORA-06512: at "GENSIGHT.PKCREATEFULLTEXTINDEXES", line 1
ORA-06512: at line 9


So after some googling I found you had to run the drdefus.sql so I did that but it reports an error;


SQL> @drdefus.sql
Creating lexer preference...
begin
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10701: preference SYS.DEFAULT_LEXER already exists
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.CTX_DDL", line 55
ORA-06512: at line 2


Creating wordlist preference...
begin
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10701: preference SYS.DEFAULT_WORDLIST already exists
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.CTX_DDL", line 55
ORA-06512: at line 2


Creating stoplist...
begin
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-12500: stoplist DEFAULT_STOPLIST already exists
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.CTX_DDL", line 789
ORA-06512: at line 2


Creating default policy...
begin
*
ERROR at line 1:
ORA-20000: Oracle Text error:
DRG-10507: duplicate index name: DEFAULT_POLICY_ORACONTAINS
ORA-06512: at "CTXSYS.DRUE", line 157
ORA-06512: at "CTXSYS.CTX_DDL", line 1652
ORA-06512: at line 2