Executing an Import Datapump ORA-39083 and ORA-13249
(Doc ID 558734.1)
Last updated on JANUARY 30, 2022
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.
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |