ORA-20001 Or ORA-01400 Raised During Impdp When SDE.ST_GEOMETRY Domain Index Is Involved (Doc ID 2158966.1)

Last updated on AUGUST 22, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Oracle Spatial and Graph - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms


When performing a DataPump import that involves ESRI (SDE.ST_GEOMETRY) Domain Indexes, it generates the errors:

...
. . imported "SDE"."ST_GEOMETRY_COLUMNS" 23.54 KB 360 rows
...
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-20001: Object FIBER.FIBERMISCANNO.SHAPE exists in ST_GEOMETRY_COLUMNS.
Failing sql is:
BEGIN
SDE.st_type_export.validate_spref('FIBER','NAD_1983_StatePlane_Washington_South_FIPS_4602_Feet',4,-119259499.999438,-96173399.9992985,3906.24999636202,0,1,0,1,999900000000000000000000000000000000,1989483.77735594,322117.728201985,3
23953.278155685,999900000000000000000000000000000000,-999900000000000000000000000000000000,9999000000000000000000000000000000
...
ORA-39083: Object type INDEX failed to create with error:
ORA-20001: Object FIBER.A900.SHAPE exists in ST_GEOMETRY_COLUMNS.
Failing sql is:
BEGIN
SDE.st_type_export.validate_spref('FIBER','NAD_1983_StatePlane_Washington_South_FIPS_4602_Feet',4,-119259499.999438,-96173399.9992985,3906.24999636202,0,1,0,1,999900000000000000000000000000000000,1989483.77735594,322117.728201985,3
23953.278155685,999900000000000000000000000000000000,-999900000000000000000000000000000000,9999000000000000000000000000000000
Job "SYSTEM"."SYS_IMPORT_FULL_01" completed with 24 error(s) at 15:09:11

Note:
Instead of ORA-20001, we can hit:

...
ORA-39083: Object type INDEX failed to create with error:
ORA-01400: cannot insert NULL into ("SDE"."ST_SPATIAL_REFERENCES"."SRID")
Failing sql is:
BEGIN
SDE.st_type_export.validate_spref('FIBER','NAD_1983_StatePlane_Washington_South_FIPS_4602_Feet',4,-119259499.999438,-96173399.9992985,3906.24999636202,0,1,0,1,999900000000000000000000000000000000,1989483.77735594,322117.728201985,3
23953.278155685,999900000000000000000000000000000000,-999900000000000000000000000000000000,9999000000000000000000000000000000
...

 

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