Bug Number BUG-000094243
Submitted Feb 17, 2016
Modified Jan 21, 2021
Severity Critical
Applies To ArcSDE/Enterprise Geodatabase
Version Found 10.3.1
Prog Language N/A
Server Platform
Client Platform
Database Oracle
Locale N/A
Status Implemented
Version Fixed 10.6.0
SP Fixed 10.6 Approved

Bug BUG-000094243


The full export of the Oracle Data Pump causes the Data Pump Import utility (impdp) to fail with the error, "Error: ORA-01400" for ST domain indexes.

Additional Information


Alternate Solution

Instead of creating a full export data pump file, create an export for user schemas and import the schemas using the following example workflow:

- expdp directory=EXPDIR schemas=SDE,GIS,DATA_OWNER logfile=schema_expdp.log
- impdp directory=IMPDIR schemas=SDE logfile=sde_schema_impdp.log
- Recompile any invalid objects for the SDE schema.
- impdp directory=IMPDIR schemas=GIS,DATA_OWNER logfile=other_schemas_impdp.log