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
Subscribe to:
Post Comments (Atom)
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
ReplyDeleteGood 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
ReplyDeleteYour 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شركة تنظيف بالطائف
ReplyDeletehttps://medium.com/@naklafshdmam/
شركة نقل عفش بالمدينة المنورة
شركة تنظيف بالطائف
I read this article. I think You put a lot of effort to create this article. I appreciate your work.
ReplyDeletethesis Writing Service
Really looking forward to read more
ReplyDeleteMona
في مكة المكرمة اسسنا افضل شركة تقدم خدمات منزلية عالية الجودة مثل نقل العفش تجدنا افضل شركة نقل عفش بمكة نقدم خدمات نقل الاثاث باحترافية وتوجد ايضا شركة مكافحة حشرات بمكة تقدم خدمات جيدة وتمتلك عمالة مدربة ومبيدات حشرية آمنة ومضمونة وفعالة وقد تحتاج الى افضل شركة تنظيف كنب بمكة المكرمة لكي تقوم بتعقيم منزلك بعد اعمال مكافحة الحشرات داخل المنزل وايضا تحتاج الى شركة تنظيف منازل بمكة للقيام بأعمال تنظيف المنزل سواء كان مفروشا او جديدا وقبل هذا تحتاج الى تنظيف خزان مياهك بالتواصل مع تنظيف خزانات المياه بمكة المكرمة لكي تحافظ على خزانك من التلوث وبالتالي تستخدم مياه نظيفة
ReplyDeleteتجدنا في منطقة الجنوب في كل المحافظات نقدم خدمة نقل عفش مع الفك والتركيب بواسطة عمالة متميزة وفنيين خبرة وسيارات مؤمنة
ReplyDelete- شركه نقل عفش بابها
- شركه نقل عفش بخميس مشيط
- شركه نقل عفش بالباحة
- شركه نقل عفش بمحايل عسير
- شركه نقل عفش بجازان
- شركه نقل عفش بنجران
- شركه نقل عفش بشرورة
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.
ReplyDeleteij.start.canon
ReplyDeleteis the manufacturer site to download Canon printer drivers. Install and set up Canon Printer from https: //ij.start.canon and obtain high-quality printing documents straightforwardly.
https//ij.start.cannon is actually the official site of ij start canon that helps you install the latest printer drivers and software. Visiting http //ij.start.cannon
provides you a complete list of all canon printers where you’ve to select your printer model and download the correct setup file
Canon IJ Network Tool is a toolkit software with the options to keep a check on most of your Canon printer network settings and adjust them according to your requirements.
ReplyDeleteCanon IJ Printer Utility is a complete software package meant to adjust and modify the configurations of your printer device as per the requirement. It is one of the essential utility software offered by Canon to ease your printer configuration alteration using a few clicks.
ReplyDeleteCanon.com/ijsetup/mg2500
is the Canon support link to get you the latest printer drivers and software to set up your PIXMA MG2500 or MG2520.
Nice...
ReplyDeleteIt's a very powerful article. I really like this post. Thank you so much for sharing this.
putlocker
kissanime