Ora-29855 Error Occurred In The Execution Of Odciindexcreate
Contents |
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases Request Case Start ora-06512: at line 366 Chat Back to results Print Share Is This Content Helpful? ora-29855 error occurred in the execution of odciindexcreate routine ora-20000 oracle text error Search on GeoNet Submit to ArcGIS Ideas Error: ORA-29855: error occurred in the execution of ODCIINDEXCREATE 29855. 00000 - "error occurred in the execution of odciindexcreate routine" routine Error Message When attempting to create a spatial index on a st_geometry attribute with SQL, the command fails with the following Oracle error:"ORA-29855 error ora-06512: at line 10 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 2 parameters('st_srid=12, st_grids=25000');CREATE INDEX shp_idx_1k ON st_relation_perf (shape) INDEXTYPE
Ora-13203: Failed To Read User_sdo_geom_metadata View
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-377-4575 Name Email URL Please rate your online support experience with Esri's Support website.* Poor Below Satisified Satisfie
SQL Server PRODUCTSDiscussion & Resources Benchmark Factory Code Tester for Oracle SharePlex SQL Navigator SQL Optimizer Spotlight Stat Toad Intelligence Central Toad Data Modeler Toad Data Point
Drg-10700
Toad Extension for Eclipse Toad for Hadoop Toad for IBM DB2 Toad maximo ora-29855: error occurred in the execution of odciindexcreate routine for Oracle Toad for MySQL Toad for SQL Server Toad for SAP Solutions Toad MAC Edition ora-29855 ora-20000 drg-10700 ora-06512 Home » Platforms » Oracle » Oracle Blog » Spatial Indexes and Oracle Errors. How to fix. Spatial Indexes and Oracle Errors. How to fix. Oracle Community Join Overview http://support.esri.com/technical-article/000010701 Forum Blog Wiki Members Blog Options Print Comment RSS Feed Tweet Related Posts Installing Locator or Spatial on 11g by Norm [TeamT] on 15 May 2012 0 comments How to fix "cant open scr home dir scls_scr_getval" error by Deiby Gomez on 23 Jan 2016 0 comments How to selectively optimize an Oracle Text index by Aris Prassinos on http://www.toadworld.com/platforms/oracle/b/weblog/archive/2013/05/20/spatial-indexes-and-oracle-errors-how-to-fix 22 Aug 2014 0 comments View More Spatial Indexes and Oracle Errors. How to fix. Follow Norm [TeamT] / 5.20.2013 at 2:32pm If, like me, you have suffered from ORA-29902 Error in executing ODCIIndexStart() routine errors where Spatial indexes are involved, the following might help you fix it. The error involved in the following has been extracted from a log file for a system which doesn't use Spatial or Locator itself, but calls out to a separate database which does have Locator installed. This latter database was created using Transportable Tablespaces, exported from 10.2.0.5 Enterprise Edition on HP-UX and imported into 11.2.0.3 Standard Edition on Linux x86-64. There were a number of errors creating a few of the spatial indexes on tables, like the one that follows in the example, that had zero rows in them. Oracle Support assured us that this was not a problem. And we believed them. Sigh! The Problem The following query demonstrates the problem. CONNECT CADDBA/password SELECT * FROM TEXT_FORESHORE A WHERE MDSYS.SDO_RELATE( A.GEOM, MDSYS.SDO_GEOMETRY(2003,81989, NULL, MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3), MDSYS.SDO_ORDINATE_AR
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 on and reload this https://community.oracle.com/thread/2215634 page. Please enter a title. You can not post a blank http://www.dbforums.com/showthread.php?1656060-ORA-29855-error-occurred-in-the-execution-of-ODCIINDEXCREATE-routine message. Please type your message and try again. More discussions in Spatial All PlacesDatabaseOracle Database + OptionsSpatial This discussion is archived 9 Replies Latest reply on Feb 3, 2012 3:57 PM by Ying Hu-Oracle Error while importing data into Oracle 11gr2 with arcsde 9.3.1 user12134253_xavierite Apr 27, error occurred 2011 8:05 AM I am getting error while importing the data into oracle 11g r2. We are using arcsde 9.3.1 It seems to be having some problem with spatial index creation. kindly help IMP-00017: following statement failed with ORACLE error 29855: "CREATE INDEX "A3032_IX1" ON "DGN_POLYLINE_2D" ("SHAPE" ) INDEXTYPE IS "MDS" "YS"."SPATIAL_INDEX"" IMP-00003: ORACLE error 29855 encountered ORA-29855: error occurred in 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 spatial index: [mdrcrtxfergm] ORA-13249: Error in spatial index: [mdpridxtxfergm] ORA-13200: internal error [ROWID:AAAT5pAA9AACIy5AAQ] in spatial indexing. ORA-13206: internal error [] while creating the spatial index ORA-13033: Invalid data in the SDO_ELEM_INFO_ARRAY in SDO_GEOMETRY object ORA-06512: at "MDSYS I have the same question Show 0 Likes(0) 1924Views Tags: none (add) arcgisContent tagged with arcgis, creationContent tagged with creation, errorContent tagged with error, esriContent tagged with esri, indexContent tagged with index, sdo_sridContent tagged with sdo_srid, spatialContent tagged with spatial, spatial_indexContent tagged with spatial_index This content has been marked as final. Show 9 replies 1. Re: Error while importing data into Oracle 11gr2 with arcsde 9.3.1 ToM2 Apr 27, 2011 10:32 AM (in response to user12134253_xavierite) Hi, You should check geometry before index creation: 1 using functions validate_geometry_with_context.(function check polygon ring rotation, first point on ring = end point, double vertexes, etc...) if functions return false you must use
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_