DOYENSYS Knowledge Portal

We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal

Monday, June 27, 2016

DRG-10701: preference CTXSYS.DEFAULT_LEXER already exists

While creating oracle text indexes when we get below error.


DRG-10701: preference CTXSYS.DEFAULT_LEXER already exists
DRG-10701: preference CTXSYS.DEFAULT_WORDLIST already exists
DRG-12500: stoplist DEFAULT_STOPLIST already exists
DRG-12500: stoplist EXTENDED_STOPLIST already exists

Please execute the below.

conn ctxsys/******
  ctx_ddl.drop_preference ('DEFAULT_LEXER');
  ctx_ddl.drop_preference ('DEFAULT_WORDLIST');
  ctx_ddl.drop_stoplist ('DEFAULT_STOPLIST');
  ctx_ddl.drop_stoplist ('EXTENDED_STOPLIST');

ORA-20000: Oracle Text error:
DRG-10507: duplicate index name: DEFAULT_POLICY_ORACONTAINS
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.CTX_DDL", line 1148
ORA-06512: at line 2

conn ctxsys/******

select idx_id from ctxsys.dr$index where idx_name='DEFAULT_POLICY_ORACONTAINS';

delete from ctxsys.dr$index_value where IXV_IDX_ID = 1083;
delete from ctxsys.dr$index_object where IXO_IDX_ID = 1083;
delete from ctxsys.dr$index where idx_id = 1083;

No comments: