Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com
http://www.free-online-exams.com
Problem Description: Index Creation failed with Oracle Text errors
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-12504: stoplist CTXSYS.DEFAULT_STOPLIST does not exist
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364
Explanation:
DEFAULT_STOPLIST Not created.
Solution:
Need to run drdefus .sql to create DEFAULT_STOPLIST .
Run the drdefus.sql as CTXSYS user.
SQL> conn ctxsys/ctxsys
SQL> @$ORACLE_HOME//ctx/admin/defaults/drdefus.sql
Drop the index.
SQL> Drop index cs_b_document_subject ;
and recreate the Index.
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine
ORA-20000: Oracle Text error:
DRG-12504: stoplist CTXSYS.DEFAULT_STOPLIST does not exist
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364
Explanation:
DEFAULT_STOPLIST Not created.
Solution:
Need to run drdefus .sql to create DEFAULT_STOPLIST .
Run the drdefus.sql as CTXSYS user.
SQL> conn ctxsys/ctxsys
SQL> @$ORACLE_HOME//ctx/admin/defaults/drdefus.sql
Drop the index.
SQL> Drop index cs_b_document_subject ;
and recreate the Index.
No comments:
Post a Comment