Drg-50857 Oracle Error
Contents |
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies ora-29855: error occurred in the execution of odciindexcreate routine of this site About Us Learn more about Stack Overflow the company
29855. 00000 - "error Occurred In The Execution Of Odciindexcreate Routine"
Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask
Ora-06512: At "ctxsys.textindexmethods", Line 366
Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it
Drg-10700: Preference Does Not Exist
only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top Privileges needed for Oracle Text up vote 3 down vote favorite I'm new to Oracle Text and I am using it to support a search feature in an application I have written. The everything ora-20000: oracle text error: seems to be working correctly except I'm not happy with the fact that I had to store a bunch of things in the ctxsys schema in order to get around insufficient privilege issues. (This is with Oracle 10gR2). Here is the SQL script I have to set up Oracle Text for my application -- Since the CTXSYS schema was created when Oracle Text was installed -- it does not yet have permission to select on certain tables it needs to -- for the below procedure grant select on dmg.table1 to CTXSYS; grant select on dmg.table2 to CTXSYS; grant select on dmg.table3 to CTXSYS; grant select on dmg.table4 to CTXSYS; grant select on dmg.table5 to CTXSYS; create or replace procedure ctxsys.attr_indexing_procedure ( rid in rowid, tlob in out NOCOPY clob ) is begin -- This procedure queries the above five tables to extract text and combine it into a single document placed into tlob end; / begin ctx_ddl.create_preference('dmg.my_datastore', 'user_datastore' ); ctx_ddl.set_attribute( 'dmg.my_datastore', 'procedure', 'CTXSYS.attr_indexing_procedure' ); end; / begin ctx_ddl.create_preference( 'dmg.my_index_lexer', 'BASIC_LEXER' ); ctx_ddl.set_attribute( 'dmg.my_index_lexer', 'base_letter', 'YES'); end; / begin ctx_ddl.create_preference('dmg.MY_STEM_FUZZY_PREF', 'BASIC_WORDLIST'); ctx_ddl.set_attribute('dmg.MY_STEM_FUZZY_PREF','STEMMER','ENGLISH'); ctx_ddl.set_attribute('dmg.MY_STEM_FUZZY_PREF','FUZZY_MATCH','ENGLISH'); ctx_ddl.set_attribute('dmg.MY_STEM_FUZZY_PREF','FUZZY_SCORE','0'); ctx_ddl.set_attribute('dmg.MY_STEM_FUZZY_PREF','FUZZY_NUMRESULTS','5000'); ctx_ddl.set_attribute('dmg.MY_STEM_FUZZY_PREF','SUBSTRING_INDEX','TRUE'); ctx_ddl.set_attribute('dmg.MY_STEM_FUZZY_PREF','PREFIX_INDEX','TRUE'); ctx_ddl.set_attribute('dmg.MY_STEM_FUZZY_PREF','WILDCARD_MAXTERMS','5
indexes privileges , several privileges are granting to the user owns the indexes. These privileges are enough if you want to create , sync drg-10700: preference does not exist: global_lexer and ptimize the indexes excpet the optimization with rebuild option. This option drg-50857: oracle error in dretbase requires the create trigger option beacuse Optimize Rebuild uses a trigger to capture changes made during the optimize. ora-29855 ora-20000 drg-10700 ora-06512 e.g connect myuser/pass exec ctx_ddl.OPTIMIZE_INDEX('MY_TEXT_IDX','REBUILD'); BEGIN ctx_ddl.OPTIMIZE_INDEX('MY_TEXT_IDX','REBUILD'); END; * ERROR at line 1: ORA-20000: Oracle Text error: DRG-50857: oracle error in drvddl.IndexOptimizeRebuild ORA-01031: insufficient privileges ORA-06512: at "CTXSYS.DRUE", line http://dba.stackexchange.com/questions/33923/privileges-needed-for-oracle-text 160 ORA-06512: at "CTXSYS.CTX_DDL", line 1042 ORA-06512: at line 1 After granting the CREATE TRIGGER privilege to MYUSER command executed succesfully !! Αναρτήθηκε από Agisilaos Stamatopoulos στις 10:31 AM 1 comment: AnonymousMay 17, 2013 at 9:40 AMthanks for share..ReplyDeleteAdd commentLoad more... Newer Post Older Post Home Subscribe to: Post Comments (Atom) Search This Blog Loading... Blog Archive ► http://agstamy.blogspot.com/2013/04/oracle-text-error-drg-50857-oracle.html 2016 (1) ► August (1) ► 2015 (6) ► October (2) ► June (2) ► March (2) ► 2014 (12) ► October (1) ► August (1) ► July (2) ► May (1) ► April (1) ► February (6) ▼ 2013 (12) ► November (1) ► September (4) ► August (1) ► June (2) ▼ April (1) Oracle Text Error : DRG-50857: oracle error in drv... ► February (3) ► 2012 (18) ► November (4) ► October (2) ► September (1) ► July (5) ► June (1) ► May (1) ► April (1) ► March (1) ► February (2) ► 2011 (39) ► December (1) ► November (4) ► October (2) ► September (1) ► August (1) ► July (8) ► June (1) ► May (4) ► April (1) ► March (7) ► February (5) ► January (4) ► 2010 (36) ► December (4) ► November (7) ► October (2) ► September (6) ► July (3) ► June (2) ► May (5) ► April (2) ► March (1) ► February (2) ► January (2) ►
Messages :: Show Polls :: Message Navigator E-mail to friend Error during Context Index Creation http://www.orafaq.com/forum/t/155804/ for a Table of 235 Million Records (2 threads merged by bb) [message #446515] Tue, 09 March 2010 00:11 aditya532 Messages: 3Registered: March 2010 Junior Member Hi, I am a beginner in Oracle Text, and have been extensively going through the available official documentation. I have been trying to create oracle error a context index on a table of 235 Million Records using User_Datastore and MDATA section groups. However, the index creation runs for 30-35 Hours and fails with the below mentioned error (happened all 2-3 times that i tried):- SQL*Plus: Release 9.2.0.1.0 - Production on Mon Mar 8 12:23:57 2010 Copyright (c) error occurred in 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production With the Partitioning, OLAP, Data Mining and Real Application Testing options 'Creating the context index xxcss_qot_line_ctx_indx' CREATE INDEX xxcss_qot_line_ctx_indx * ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-50857: oracle error in dreii0fsh ORA-01400: cannot insert NULL into ("APPS"."DR$XXCSS_QOT_LINE_CTX_INDX$I"."TOKEN_TEXT") ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364 Nothing is available in ctx_user_index_errors or logs. The index create script and the relevant parameter preferences that i had used are below :- CREATE INDEX xxcss_qot_line_ctx_indx ON apps.xxcss_qot_lines_search_bk (dummy) INDEXTYPE IS ctxsys.CONTEXT PARAMETERS (' datastore xxcss_qot_lines_search_ds section group xxcss_qot_lines_search_sg storage xxcss_qot_lines_search_sf filter ctxsys.null_filter lexer xxcss_qot_lines_search_lx stoplist ctxsys.empty_stoplist memory 50m transactional' ); /* Formatted on 2010/03/09 11:16 (Formatter Plus v4.8.8) */ BEGIN ctx_ddl.create_preference ('xxcss_qot_lines_search_ds', 'user_datastore'); ctx_ddl.set_attribute ('xxcss_qot_lines_search_ds', 'procedure', 'apps.xxcss_qot_search_mdata_b.lines_search_indx_proc' ); END; BEGIN ctx