Ora-29855 Error Occurred In The Execution Of Odciindexcreate Routine
Contents |
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases
Ora-06512: At Line 366
Request Case Start Chat Back to results Print Share ora-29855 error occurred in the execution of odciindexcreate routine ora-20000 oracle text error Is This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Error: ORA-29855: error occurred 29855. 00000 - "error occurred in the execution of odciindexcreate routine" in the execution of ODCIINDEXCREATE routine Error Message When attempting to create a spatial index on a st_geometry attribute with SQL, the command
Ora-06512: At Line 10
fails with 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
Ora-13203: Failed To Read User_sdo_geom_metadata View
IS sde.st_spatial_index 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 Pri
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) drg-10700 Twitter(1) Uncategorized(1) VirtualBox(3) Welcome(2) Pages About Linux A Tale of Failure,
Maximo Ora-29855: Error Occurred In The Execution Of Odciindexcreate Routine
Success and Open Source. Oracle Resources Blog Archives Blog Archives Select Month September 2016 (1) August 2016 (4) ora-29855 ora-20000 drg-10700 ora-06512 June 2016 (2) May 2016 (1) March 2016 (2) February 2016 (2) January 2016 (1) December 2015 (1) November 2015 (1) October 2015 (1) September 2015 (1) August 2015 http://support.esri.com/technical-article/000010701 (3) June 2015 (1) April 2015 (2) 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) http://qdosmsq.dunbar-it.co.uk/blog/2013/05/spatial-indexes-and-oracle-errors-how-to-fix/ February 2013 (5) January 2013 (2) December 2012 (3) November 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 E
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 https://community.oracle.com/thread/3757956 reload this page. Please enter a title. You can not post a blank message. Please type your message and try again. More discussions in Multimedia (formerly interMedia) All PlacesOracle http://www-01.ibm.com/support/docview.wss?uid=swg21405526 CommunityArchived ForumsMultimedia (formerly interMedia) This discussion is archived 0 Replies Latest reply on Jun 30, 2015 9:08 AM by 2626750 ORA-29855: error occurred in the execution of ODCIINDEXCREATE error occurred 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 trying to create an index and got the following errors:(NOTE: I am creating this using SYSTEM account, similar to what error occurred in 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") USING INDEX TABLESPACE "OTHER_DATA" ENABLE ) TABLESPACE "OTHER_DATA" XMLTYPE COLUMN "RES" STORE AS CLOB ( TABLESPACE "OTHER_DATA" ENABLE STORAGE IN ROW CHUNK 4096 PCTVERSION 10 NOCACHE LOGGING ) ; CREATE INDEX "INFOOWNER"."XML_NEWS_IDX" ON "INFOOWNER"."XML_NEWS" (SYS_MAKEXML("SYS_NC00005$")) INDEXTYPE
text; text search; text index; ORA-29855; ctxsys Technote (troubleshooting) Problem(Abstract) java.sql.SQLException: ORA-29855: error occurred in 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 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: 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 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