Importing a Spatial Index Fails with ORA-29855, ORA-13249, ORA-01031 (Doc ID 340521.1)

Last updated on MARCH 01, 2017

Applies to:

Oracle Spatial and Graph - Version 10.1.0.1 to 11.2.0.4 [Release 10.1 to 11.2]
Information in this document applies to any platform.

Symptoms

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 "
""MDSYS"."SPATIAL_INDEX""
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

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms