Oracle Error 29855 Encountered
Contents |
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases Request Case Start Chat Back to results Print Share imp-00017: following statement failed with oracle error 2430 Is This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Bug: imp-00003 IMP-00017: following statement failed with ORACLE error 29855 Description IMP-00017: following statement failed with ORACLE error 29855:
Imp-00017: Following Statement Failed With Oracle Error 959
"CREATE INDEX "A197_IX1" ON "USACAPITALS" ("FEATURE" ) INDEXTYPE IS "MDSYS"" "."SPATIAL_INDEX" PARAMETERS ('SDO_COMMIT_INTERVAL = 1000')" IMP-00003: ORACLE error 29855 encountered ORA-29855: error occurred in the execution of ODCIINDEXCREATE
Imp-00017 Following Statement Failed With Oracle Error 1917
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-13365: Layer SRID does not match geometry SRID ORA-06512: at "MDSYS.SDO_INDEX_METHOD_9I", line 7 ORA-06512: at line 1 Cause Importing Oracle 8.1.7 dump files into Oracle 9i may fail if they contain Oracle Spatial feature classes loaded ora-29855: error occurred in the execution of odciindexcreate routine using shp2sde prior to ArcSDE 8.2 Patch 1. This error occurs when trying to build the Oracle Spatial spatial index. As mentioned in the error message, the SRID in the layer does not match the SRID in the one or more geometries, or more precisely, the SRID in the entry in USER_SDO_GEOM_METADATA for the table does not match MDSYS.SDO_GEOMETRY.SDO_SRID in one or more rows in the table. Prior to ArcSDE 8.2 Patch 1, ArcSDE did not check whether the Oracle Spatial SRID in USER_SDO_GEOM_METADATA for a table matched the SDO_GEOMETRY.SDO_SRID in each row of the table. In Oracle 8i, this was not required. It is now required in Oracle 9i, and ArcSDE was changed to meet this new requirement in ArcSDE 8.2 Patch 1. Now, importing a shapefile into an Oracle Spatial table using ArcCatalog sets the Oracle Spatial SRID to NULL in each feature's record and in USER_SDO_GEOM_METADATA. Workaround After loading Oracle Spatial data using an earlier version of shp2sde, each row in the new table can be up
Early Adopter Program ArcGIS Ideas Esri Support Services ArcGIS Blogs ArcGIS Code Sharing Product Life Cycles Manage Cases Request Case Start Chat Back to results Print Share Is This Content Helpful? Search on GeoNet Submit to ArcGIS Ideas Error: Encountering Oracle error ORA-29855 when creating an st_spatial_index in Oracle Error Message When creating an ST_Geometry spatial index, sde.st_spatial_index, the following Oracle error may display: "ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine".The following example demonstrates the CREATE INDEX statement http://support.esri.com/technical-article/000005525 and the Oracle error when creating a st_spatial_index on the BUILDINGS table's shape attribute.Code:SQL> CREATE INDEX shape_idx ON buildings (shape) INDEXTYPE IS 2 sde.st_spatial_index PARAMETERS ('ST_GRIDS=500 ST_SRID=38 3 ST_COMMIT_ROWS=10000 PCTFREE 0 INITRANS 4');CREATE INDEX shape_idx ON buildings (shape) INDEXTYPE IS*ERROR at line 1:ORA-29855: error occurred in the execution of ODCIINDEXCREATE routineORA-06502: PL/SQL: numeric or value http://support.esri.com/technical-article/000009830 error: character to number conversion errorORA-06512: at "SDE.SPX_UTIL", line 182ORA-06512: at "SDE.SPX_UTIL", line 680ORA-06512: at "SDE.ST_DOMAIN_METHODS", line 925 Cause A carriage return is included in the parameters clause, which is passed to the sde.spx_util procedure used for parsing the parameters string.The procedure's role is to parse the parameters clause and extract each token as an argument for the creation of the st_spatial_index.When carriage returns are present, this additional character causes the parsing routines to fail while converting a string to a number.The carriage returns are created each time a new line is inserted in the parameters clause. Solution or Workaround To avoid the Oracle error encountered in the sde.spx_util procedure, do not enter any carriage returns in the parameters clause of the CREATE INDEX statement.For example, the carriage line entered at the end of line 2 after the st_srid=38 argument causes the creation of the index to fail.Code:SQL> CREATE INDEX shape_idx ON buildings (shape) INDEXTYPE IS 2 sde.st_spatial_index PARAMETERS ('ST_GRIDS=500 ST_SRID=38 3 ST_COMMIT_ROWS=10000 PCTFRE
Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Scripts Administration ORA-HOWTO Web and Mobile SQL*Plus Data Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Papers Administration ORA-HOWTO Web and Mobile SQL*Plus Data http://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=12911 Warehousing Installation Networking Backup Recovery Security Tuning PLSQL Oracle Applications Forum All threads Best last http://www.asjava.com/oracle/oracle-error-drg-10758-index-owner-does-not-have-the-privilege-to-use-file-or-url-datastore/ month Links Oracle official Oracle Technical Info Tools (free) Tools (commercial) Oracle FAQ Other DBA-sites Oracle development Not Oracle specific Oracle Blogs Imho Fqa Pirats | Start a new thread | All threads | Best last month | Question Most of my databases are on version 12.1 11.2 11.1 10.2 10.1 or lower Answer and see the results DBA Top oracle error 10 1 M. Cadot 35800 2 F. Diaz 34000 3 J. Schnackenberg 16400 4 B. Vroman 15450 5 A. Kavsek 15250 6 P. Wisse 14250 7 T. Boles 13500 8 M. Hidayathullah ... 10900 9 A. Hudspith 9200 10 A. Khan 4100 About Advertise here Download PLATOThe free tool for auditing and tuning your databaseVersion 55 now available Sep 02, 2016 The DBA-Village forum as RSS feed Site StatisticsEver registered users47788Total active users2117Act. users last following statement failed 24h9Act. users last hour1Registered user hits last week756Registered user hits last month6432 Go up import spatial data failed Next thread: batch file Prev thread: Index Creation query Message Score Author Date Dear all, I had to copy a schema from production ...... Zoran Hudec Jun 14, 2005, 07:29 Have u checked MetaLink Note:121899.1 and Note...... Rene Borchert Jun 14, 2005, 08:08 Rene, Thanks for these links - I have checked, an...... Zoran Hudec Jun 14, 2005, 08:38 I made a mistake while cleaning up the target sche...... Zoran Hudec Jun 15, 2005, 05:01 1. Export and import like you do it normally, then...... raman maramraj Jan 04, 2006, 17:30 Raman, Thanks for the reply. We ended up with ...... Zoran Hudec Jan 04, 2006, 20:31 Follow up by mail Click here Subject: import spatial data failed Author: Zoran Hudec, Australia Date: Jun 14, 2005, 07:29, 4149 days ago Oracle info: 9.2.0.4 Error info: ORA-13249: Multiple index entries in mdsys.sdo_index_metadata_table Message: Dear all, I had to copy a schema from production to test, using export/import. I have dropped all the objects owned by the owner (there area other owners we don't want to touch). After hours of loading( lots of LOBs), i finally got the errors like this: IMP-00017: following statement failed with ORACLE error 29855: "CREATE INDEX "TEST_SPATIAL_IDX" ON "TEST" ("GEOMETRY" ) INDEXT
Tutorials1. Tomcat2. Jetty OtherOther Tutorials1. Ant Back to top Oracle error: DRG-10758: index owner does not have the privilege to use file or URL datastore Posted by: admin On October 25, 2011 Filed under: Oracle Version 1.0Copyright © 2007 - 2013 Asjava.com Oracle Error :: DRG-10758 Index owner does not have the privilege to use file or URL datastore Cause. Error details: When you tried to create an index, if the index owner does not have the privilege to use file or URL datastore, it will occur the following error stack: IMP-00017: following statement failed with ORACLE error 29855: "CREATE INDEX "FILES_CONTENT_IDX" ON "FILES" ("CONTENT_URL" ) INDEXTYPE IS " ""CTXSYS"."CONTEXT" PARAMETERS ('DATASTORE CTXSYS.FILES_CONTENT_PREF FILTER " "CTXSYS.INSO_FILTER LEXER CTXSYS.ATTACHMENT_LEXER STORAGE CTXSYS.FILES_CONTE" "NT_STORAGE ')" IMP-00003: ORACLE error 29855 encountered ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine ORA-20000: Oracle Text error: DRG-10758: index owner does not have the privilege to use file or URL datastore Cause: Index owner does not have the role defined in FILE_ACCESS_ROLE. Solution/Action: Grant index owner the appropriate role How to do with Solution/Action in detail: To determine if the ability to use an Oracle Text URL datastore is already granted to a database role: 1.Start SQL*Plus and connect to the database where Oracle Application Express is installed as SYS specifying the SYSDBA role. For example: On Windows:
SYSTEM_DRIVE:\ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password * On UNIX and Linux: $ sqlplus /nolog SQL> CONNECT SYS as SYSDBA Enter password: SYS_password Run the following command: SELECT par_value FROM ctxsys.ctx_parameters WHERE par_name = ‘FILE_ACCESS_RO