Odciindexcreate Error
Contents |
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases ora-29855 error occurred in the execution of odciindexcreate Request Case Start Chat Back to results Print Share Is
Ora-29855 Error Occurred In The Execution Of Odciindexcreate Routine Ora-20000 Oracle Text Error
This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Error: ORA-29855: error occurred in 29855. 00000 - "error occurred in the execution of odciindexcreate routine" the execution of ODCIINDEXCREATE routine Error Message When attempting to create a spatial index on a st_geometry attribute with SQL, the command fails with
Ora-06512: At "ctxsys.textindexmethods", Line 366
the following Oracle error:"ORA-29855 error occurred in the execution of ODCIINDEXCREATE routine". Cause In this specific case, the Oracle error ORA-29855 is being encountered because the parameters string clause contains an unnecessary comma between the st_srid and st_grids parameters.Code:SQL> CREATE INDEX shp_idx_1k ON st_relation_perf (shape) INDEXTYPE IS sde.st_spatial_index maximo ora-29855: error occurred in the execution of odciindexcreate routine 2 parameters('st_srid=12, st_grids=25000');CREATE INDEX shp_idx_1k ON st_relation_perf (shape) INDEXTYPE IS sde.st_spatial_index*ERROR at line 1:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-06502: PL/SQL: numeric or value error: character to number conversion errorORA-06512: at "SDE.SPX_UTIL", line 190ORA-06512: at "SDE.SPX_UTIL", line 696ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 1438 Solution or Workaround The correct syntax for creating the index is the following:Code:SQL> CREATE INDEX shp_idx_1k ON st_relation_perf (shape) INDEXTYPE IS sde.st_spatial_index 2 parameters('st_srid=12 st_grids=25000');When creating a spatial index do not insert any commas between the arguments in the parameters clause. Created: 5/5/2016 Last Modified: 5/5/2016 Article ID: 000010701 Software: ArcSDE 9.2, 9.3, 9.3.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-3
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
Drg-10700
policies of this site About Us Learn more about Stack Overflow the company
Ora-06512: At "mdsys.sdo_index_method_10i", Line 10
Business Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered drg-50857: oracle error in dretbase Ask 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 http://support.esri.com/technical-article/000010701 them; it 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. http://dba.stackexchange.com/questions/33923/privileges-needed-for-oracle-text The everything 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_attri
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. Please turn JavaScript back https://community.oracle.com/thread/3622400 on and reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in https://sqlpatterns.wordpress.com/tag/error-occurred-in-the-execution-of-odciindexcreate-routine/ Text All PlacesDatabaseOracle Database + OptionsText This discussion is archived 2 Replies Latest reply on Oct 23, 2014 8:54 AM by Barbara Boehmer ERROR at line 1: error occurred ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-10700: preference does not exist: global_lexer ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366 user13427480 Oct 22, 2014 7:23 PM database version 11.2.0.4rac two nodeCREATE INDEX MAXIMO.ACTCI_NDX3 ON MAXIMO.ACTCI(DESCRIPTION)INDEXTYPE IS CTXSYS.CONTEXTPARAMETERS('lexer global_lexer language column LANGCODE')ERROR at line 1:ORA-29855: error error occurred in occurred in the execution of ODCIINDEXCREATE routineORA-20000: Oracle Text error:DRG-10700: preference does not exist: global_lexerORA-06512: at "CTXSYS.DRUE", line 160ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 366 I have the same question Show 0 Likes(0) 2934Views Tags: none (add) ora-29855 ora-20000 drg-10700 ora-06512 ora-06512ora-29855 ora-20000 drg-10700 ora-06512 ora-06512Content tagged with ora-29855 ora-20000 drg-10700 ora-06512 ora-06512ora-29855 ora-20000 drg-10700 ora-06512 ora-06512 This content has been marked as final. Show 2 replies 1. Re: 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: global_lexer ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line Andreas Weiden Oct 22, 2014 6:49 PM (in response to user13427480) You are in the wrong forum. Try Text Like Show 0 Likes(0) Actions 2. Re: 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: global_lexer ORA-06512: at "CTXSYS.DRUE", line 160 ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line Barbara Bo
spatial index in dynamicSQL November 3, 2014November 3, 2014Zahar HilkevichLeave a comment Executing DDL commands explicitly or with EXECUTE IMMEDIATE statement usually require special privileges granted directly (not as a part of a ROLE). With creating tables and indexes, things are really simple, you just need to grant CREATE TABLE privilege and that's it. When you need to create a special index, such as SPATIAL index, it is not obvious which privileges need to be granted. Symptoms of the problem: SQL> BEGIN 2 EXECUTE IMMEDIATE 'CREATE INDEX idx_poi_geometry ON poi_geometry(geom) INDEXTYPE IS MDSYS.SPATIAL_INDEX'; 3 END; 4 / BEGIN * ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-13249: internal error in Spatial index: [mdidxrbd] ORA-13249: Error in Spatial index: index build failed ORA-13249: Error in R-tree: [mdrcrtscrt] ORA-13231: failed to create index table [MDRT_2942E$] during R-tree creation ORA-13249: Stmt-Execute Failure: CREATE TABLE "SCOTT".MDRT_2942E$ (NODE_ID NUMBER, NODE_LEVEL NUMBER, INFO BLOB) LOB (INFO) STORE AS (NOCACHE) PCTFREE 2 ORA-29400: data cartridge error ORA-01950: no privileges on tablespace 'USERS' ORA-06512: at "MDSYS.SDO_INDEX_METHOD_10I", line 10 ORA-06512: at line 2 Elapsed: 00:00:00.07 Note, that even though the statement failed, Oracle created an object, so before retrying you need to drop it: SQL> DROP INDEX idx_poi_geometry; Index dropped. From the error message, we can conclude that there is something wrong with the tablespace privileges. And this is not something dynamic SQL specific as the plain DDL command fails with the same error: SQL> CREATE INDEX idx_poi_geometry ON poi_geometry(geom) INDEXTYPE IS MDSYS.SPATIAL_INDEX; CREATE INDEX idx_poi_geometry ON poi_geometry(geom) INDEXTYPE IS MDSYS.SPATIAL_INDEX * ERROR at line 1: ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-13249: internal