Executing an Import Datapump ORA-39083 and ORA-13249 (Doc ID 558734.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 20-Apr-2015***


Symptoms

Executing an Import Datapump the following error is generated:

ORA-39083: Object type INDEX failed to create with error: 
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine 
ORA-13249: SRID 900000000 does not exist in MDSYS.CS_SRS table 
ORA-29400: data cartridge error 
Error - OCI_NODATA 
Failing sql is: 
CREATE INDEX "SCOTT"."ARN_CEN_TXT_IX"  
ON "SCOTT"."ARN_CEN_TXT" ("GEOM") 
INDEXTYPE IS "MDSYS"."SPATIAL_INDEX"  
PARAMETERS (' SDO_INDX_DIMS=2 
    LAYER_GTYPE="POINT" SDO_RTR_PCTFREE=2 INITIAL=1024K 
    NEXT=1024K MINEXTENTS=1 MAXEXTENTS=2147483645 
ORA-39083: Object type INDEX failed to create with error: 
ORA-29855: error occurred in the execution of ODCIINDEXCREATE routine 
ORA-13249: SRID 900000000 does not exist in MDSYS.CS_SRS table 
ORA-29400: data cartridge error

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