Oracle Error Ora-29855
Contents |
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases Request ora-29855: error occurred in the execution of odciindexcreate Case Start Chat Back to results Print Share Is
Ora-06512: At "ctxsys.textindexmethods", Line 366
This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Error: ORA-29855: error occurred in
Ora-29855 Error Occurred In The Execution Of Odciindexcreate Routine Ora-20000 Oracle Text Error
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
29855. 00000 - "error Occurred In The Execution Of Odciindexcreate Routine"
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 2 ora-06512: at "mdsys.sdo_index_method_10i", line 10 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-377-4575 Name E
Bees(22) Creatures(34) Docbook(1) Gadgets & Gizmos(9) Humanity(1) Humour(3) Linux(36) NetBeans(1) Oracle(87) Personal(4) QDOSMSQ(2) Rants & Raves(36) Raspberry Pi(12) Religion(5) Twitter(1) Uncategorized(1) VirtualBox(3) ora-13203: failed to read user_sdo_geom_metadata view Welcome(2) Pages About Linux A Tale of Failure, Success and Open Source. Oracle drg-10700 Resources Blog Archives Blog Archives Select Month September 2016 (1) August 2016 (4) June 2016 (2) May 2016 maximo ora-29855: error occurred in the execution of odciindexcreate routine (1) March 2016 (2) February 2016 (2) January 2016 (1) December 2015 (1) November 2015 (1) October 2015 (1) September 2015 (1) August 2015 (3) June 2015 (1) April 2015 (2) http://support.esri.com/technical-article/000010701 December 2014 (2) November 2014 (1) October 2014 (1) September 2014 (2) August 2014 (2) June 2014 (2) March 2014 (2) January 2014 (1) December 2013 (2) November 2013 (1) September 2013 (1) August 2013 (4) July 2013 (1) June 2013 (3) May 2013 (7) April 2013 (4) March 2013 (4) February 2013 (5) January 2013 (2) December 2012 (3) November http://qdosmsq.dunbar-it.co.uk/blog/2013/05/spatial-indexes-and-oracle-errors-how-to-fix/ 2012 (4) October 2012 (4) September 2012 (2) August 2012 (5) June 2012 (1) May 2012 (4) April 2012 (3) March 2012 (3) February 2012 (7) January 2012 (3) December 2011 (3) November 2011 (6) October 2011 (1) September 2011 (1) August 2011 (1) July 2011 (1) June 2011 (5) May 2011 (3) April 2011 (1) March 2011 (2) February 2011 (2) January 2011 (3) October 2010 (3) September 2010 (3) August 2010 (5) May 2010 (4) April 2010 (2) March 2010 (3) February 2010 (2) January 2010 (1) December 2009 (2) October 2009 (1) August 2009 (2) July 2009 (3) May 2009 (6) April 2009 (4) March 2009 (4) February 2009 (3) January 2009 (5) Bees Bees For Development Harrogate and Ripon Beekeepers The British Beekeepers' Association Blogroll Greg Rahn Howard J Rogers Jonathan Lewis Julian Dyke Martin CarstenBach Miladin Modrakovic Oracle Optimizer Richard Foote Tanel Poder Charities Bees For Development Non-Believers Giving Aid Wordpress Documentation Spatial Indexes and Oracle Errors. How to fix. Send article as PDF If, like me, you have suffered from ORA-29902 Error in executing O
text; text search; text index; ORA-29855; ctxsys Technote (troubleshooting) Problem(Abstract) java.sql.SQLException: ORA-29855: error occurred in http://www-01.ibm.com/support/docview.wss?uid=swg21405526 the execution of ODCIINDEXCREATE routine during execution of updatedb scripts or configdb Cause Database imported from an export of another Oracle database and/or schema Resolving the problem You http://www.dbforums.com/showthread.php?1656060-ORA-29855-error-occurred-in-the-execution-of-ODCIINDEXCREATE-routine may receive the following error when running updatedb.bat or configdb.bat on a database that was imported from and export of a different Oracle database and/or schema. java.sql.SQLException: 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 364. You could be getting this error because a schema export will not export the Oracle Text preferences and sub-lexer definitions or the database does not error occurred in have Oracle Text indexing enabled. 1. Restore the database back to the before the start up updatedb 2. Follow the steps in the following Technote ORA-29855 Error When Running updatedb 3. If updatedb or configdb failed with the same or similar error continue with the following 4. Repeat steps 1 and 2 then, 5. Connect to the database instance specifying AS SYSDBA 6. Create the MDSYS user with a command in the following format: SQL> CREATE USER MDSYS IDENTIFIED BY
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 ACC