Importing a Spatial Index Fails with ORA-29855, ORA-13249, ORA-01031
Last updated on MARCH 01, 2017
Applies to:Oracle Spatial and Graph - Version 10.1.0.1 to 184.108.40.206 [Release 10.1 to 11.2]
Information in this document applies to any platform.
On 10g when attempting to import spatial indexes with the FROMUSER/TOUSER option, the following error occurs.
The issue can be reproduced at will with the following steps.
imp system/manager file=cola_markets.dmp fromuser=spatial_test touser=spatial_test
Import: Release 10.1.0.4.0 - Production on Wed Sep 21 06:54:15 2005
Copyright (c) 1982, 2004, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0 - Production
With the Partitioning, OLAP and Data Mining options
Export file created by EXPORT:V10.01.00 via conventional path
import done in WE8ISO8859P1 character set and UTF8 NCHAR character set
import server uses UTF8 character set (possible charset conversion)
. importing SPATIAL_TEST's objects into SPATIAL_TEST
. . importing table "COLA_MARKETS" 4 rows imported
IMP-00017: following statement failed with ORACLE error 29855:
"CREATE INDEX "COLA_SPATIAL_IDX" ON "COLA_MARKETS" ("SHAPE" ) INDEXTYPE IS "
IMP-00003: ORACLE error 29855 encountered
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_3E8B6$] during R-tree creation
ORA-13249: Stmt-Execute Failure: CREATE TABLE SPATIAL_TEST.MDRT_3E8B6$ (NODE_ID NUMBER, NODE_LEVEL
NUMBER, INFO BLOB) LOB (INFO) STORE AS (CACHE) NOLOGGING PCTFREE 2
ORA-29400: data cartridge error
ORA-1031: insufficient privileges
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms