Ora-29855 Error Occurred In The Execution
Contents |
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles ora-06512: at line 366 Manage Cases Request Case Start Chat Back to results ora-29855 error occurred in the execution of odciindexcreate routine ora-20000 oracle text error Print Share Is This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Error: 29855. 00000 - "error occurred in the execution of odciindexcreate routine" ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine Error Message When indexing Oracle Spatial tables, like this:SQL> CREATE INDEX Q2Q_POINT1_IDXSQL> ON Q2Q_POINT1(SHAPE)SQL>
Ora-06512: At Line 10
INDEXTYPE IS MDSYS.SPATIAL_INDEX;The following error occurs:ERROR at line 1:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-13203: failed to read USER_SDO_GEOM_METADATA tableORA-13203: failed to read USER_SDO_GEOM_METADATA tableORA-06512: at "MDSYS.SDO_INDEX_METHOD", line 7ORA-06512: at line 1 Cause In ALL_SDO_GEOM_METADATA, there is no row specifying this particular combination of drg-10700 OWNER, TABLE_NAME and (geometry) COLUMN_NAME. Solution or Workaround Check for a row (mistakenly inserted into ALL_SDO_GEOM_METADATA) in which one or more of these columns is incorrect.Insert a new row into USER_SDO_GEOM_METADATA (a view of ALL_SDO_GEOM_METADATA) with the correct metadata. Created: 5/5/2016 Last Modified: 5/5/2016 Article ID: 000004361 Software: ArcSDE 8.1 Is This Content Helpful? Is This Content Helpful? Yes No We're glad to know this article was helpful. How can we make this better? Submit Contact our Support Team Request Case Start Chat Questions or issues with the site? Send Feedback Privacy Contact Support USA +1-888-377-4575 Name Email URL Please rate your online support experience with Esri's Support website.* Poor Below Satisified Satisfied Above Satisfied Excellent What issues are you having with the site? How can we improve? Submit Feedback sent successfully. Error while sending mail. Loading
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. maximo ora-29855: error occurred in the execution of odciindexcreate routine Please turn JavaScript back on and reload this page. Please
Ora-13203: Failed To Read User_sdo_geom_metadata View
enter a title. You can not post a blank message. Please type your message and
Ora-29855 Ora-20000 Drg-10700 Ora-06512
try again. More discussions in Multimedia (formerly interMedia) All PlacesOracle CommunityArchived ForumsMultimedia (formerly interMedia) This discussion is archived 0 Replies Latest reply on Jun http://support.esri.com/technical-article/000004361 30, 2015 9:08 AM by 2626750 ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine when creating context index 2626750 Jun 30, 2015 9:08 AM Hi all:DB version: Oracle 10.2.0.4 on Redhat Enterprise Linux 5 (64-bit )When migrating a legacy DB from Solaris to Linux, encountered the following issue when https://community.oracle.com/thread/3757956 trying to create an index and got the following errors:(NOTE: I am creating this using SYSTEM account, similar to what I do in impdb) > CREATE INDEX "INFOOWNER"."XML_NEWS_IDX" ON "INFOOWNER"."XML_NEWS" (SYS_MAK> INDEXTYPE IS "CTXSYS"."CONTEXT" PARALLEL 1 ;CREATE INDEX "INFOOWNER"."XML_NEWS_IDX" ON "INFOOWNER"."XML_NEWS" (SYS_MAKEXML("SYS_NC00005$"))*ERROR at line 1:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-20000: Oracle Text error:DRG-50857: oracle error in drsxsopenORA-00904: "BASE"."SYS_NC00011$"."GETCLOBVAL": invalid identifierORA-06512: at "CTXSYS.DRUE", line 160ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 364The original table is like this: CREATE TABLE "INFOOWNER"."XML_NEWS" ( "RESID" RAW(16) NOT NULL ENABLE, "ANY_PATH" VARCHAR2(2000 BYTE) NOT NULL ENABLE, "CREATEDATE" DATE, "RES" "SYS"."XMLTYPE" , "LANG" VARCHAR2(10 BYTE), "FILEMODDATE" DATE, "NEWSMODDATE" DATE NOT NULL ENABLE, "NEWSID" VARCHAR2(20 BYTE), "STATUS" VARCHAR2(1 BYTE) NOT NULL ENABLE, "RELATED_STOCK" VARCHAR2(500 CHAR) NOT NULL ENABLE, "RELATED_CAT" VARCHAR2(50 CHAR) NOT NULL ENABLE, CONSTRAINT "XML_NEWS_PK" PRIMARY KEY ("RESID", "ANY_PATH", "NEWSMODDATE", "RELATED_CAT", "STATUS")
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 http://dba.stackexchange.com/questions/33923/privileges-needed-for-oracle-text of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask http://www.dbforums.com/showthread.php?1656060-ORA-29855-error-occurred-in-the-execution-of-ODCIINDEXCREATE-routine 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 error occurred 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 error occurred in 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.
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 2 of 2 Thread: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 04-30-10,02:06 #1 ukupatil View Profile View Forum Posts Registered User Join Date Jan 2006 Location Mumbai (India) Posts 11 Unanswered: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine Dear All, Currently I am working on Oracle 10g (10.2.0.4 Enterprise varsion). It is upgraded from Oracle 9i(9.2.0.6 Enterprise ). Operating system is Linux. I am facing many errors while creating a Text index on a table. While executing a procedure which drops and creates text index on table, first it raised following Error. ORA-29868:Cannot issue DDL on a domain index marked as LOADING. So I used the command to drop this index with FORCE as DROP INDEX FORCE IX_INDEXNAME; Again compiling the procedure and executing it, many errors raised as ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-04065: not executed,altered or dropped stored procedure "PUBLIC.UTL_RAW" ORA-06508: PL/SQL Could not find program unit being called "PUBLIC.UTL_RAW" ORA-06512: at "CTXSYS.DRIPARSE" line 41 ORA-06512: at "CTXSYS.DRIPARSE" line 1710 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS" line 81 Then I checked whether UTL_RAW package is available and valid or not with sql query SELECT OBJECT_NAME, OBJECT_TYPE, STATUS FROM ALL_OBJECTS WHERE OBJECT_TYPE IN('PACKAGE', 'PACKAGE BODY') AND OBJECT_NAME = 'UTL_RAW'; Package is available with VALID status in database. Then I unlocked CTXSYS account guessing one of the possibility. ALTER USER CTXSYS ACCOUNT UNLOCK; All EXECUTE grants on CTXSYS.CTX_CLS, CT