Monday, April 24, 2017

ORA-29855: error occurred DRG-10700: preference does not exist while creating Text Index


User come across an issue that creating index hanging during datapump import. We have excluded the index during export and trying to create after importing data.

CREATE INDEX "AMX"."BRR_360_TXT" ON "AMX"." BRR_360_BLOB" ("FILE_DATA")
INDEXTYPE IS "CTXSYS"."CONTEXT" PARAMETERS ('POPULATE FILTER ODP_FILTER LEXER ODP_LEXER WORDLIST ODP_WORDLIST STOPLIST ODP_STOPLIST SECTION GROUP ODP_SECTION_GROUP')
PARALLEL 4

This was the error that we got

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: ODP_FILTER
ORA-06512: at "CTXSYS.DRUE", line 160
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366

User have generated the index creating script using dbms_metadata.get_ddl. The index creating script works in case normal index.

But noticed that the index that user was creating is a Text index and we need to use different package i.e CTX_REPORT.CREATE_INDEX_SCRIPT

I have used below script on the source DB to create index for Text index

SET LONG 32000 LINES 200
SET HEAD OFF
SET PAGESIZE 10000
SET TRIMOUT ON TRIMSPOOL ON
SELECT CTX_REPORT.CREATE_INDEX_SCRIPT('<your_text_index_name>') FROM DUAL;
spool off


Regards,
Satishbabu Gunukula, Oracle ACE
http://www.oracleracexpert.com

5 comments:

  1. I enjoyed over read your blog post. Your blog have nice information, I got good ideas from this amazing blog. I am always super mario world

    ReplyDelete
  2. Good day very nice web site!! Guy... Excellent... Wonderful... І will bookmark your blog and take the feeds additionally. I’m satisfied to search out a lot ߋf helpful information right here in the publish; we need work out extra techniques on this regard, thanks for sharing. Best essay writing service

    ReplyDelete
  3. Your information is very interesting, I am curious and it makes me have different views about them. five nights at freddy’s Thank you very much.

    ReplyDelete
  4. Several factors make writing a tough process. Before you begin writing the paper, you have to complete pre-writing tasks, which include reading and interpreting the article, brainstorming and organizing your thoughts into an outline or a rough draft https://cheap-papers.com/buy-article-review.php.

    ReplyDelete