Ora-39083 Ora-20001 While Performing An Schema Import (Impdp) With SDE.ST_GEOMETRY Types Domain Indexes

(Doc ID 1328706.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Spatial and Graph - Version 10.2.0.5 and later
Information in this document applies to any platform.
***Checked for relevance on 01-Nov-2013***

Symptoms


Full export using expdp on db "A" and then used impdp to import into db "B" a specific user schema.

35 domain indexes fail to import

...
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/GRANT/OWNER_GRANT/OBJECT_GRANT
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/INDEX
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/CONSTRAINT/CONSTRAINT
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/FUNCTION/ALTER_FUNCTION
Processing object type DATABASE_EXPORT/SCHEMA/PROCEDURE/ALTER_PROCEDURE
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-39083: Object type INDEX failed to create with error:
ORA-20001: Object TPO_OWNER.AMS_DF_POINT.SHAPE exists in ST_GEOMETRY_COLUMNS.
Failing sql is:
BEGIN
SDE.st_type_export.validate_spref('TPO_OWNER','NAD_1983_Lambert_Conformal_Conic',4,3410000,1920000,325.870052352048,0,1,0,1,999900000000000000000000000000000000,9212858.62831334,2275276.24328892,6892398.66414443,999900000000000000000000000000000000,-999900000000000000000000000000000000,999900000000000000000000000000000000,-99990000000000000000000000
ORA-39083: Object type INDEX failed to create with error:
ORA-20001: Object TPO_OWNER.AMS_FSA_AREA.SHAPE exists in ST_GEOMETRY_COLUMNS.
Failing sql is:
BEGIN
.
.
.

The domain indexes are based on SDE.ST_GEOMETRY (MDSYS does not even exist) this is SDE type.

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