laptop and a wrench

Bug

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.

Last Published: September 15, 2017 ArcSDE/Enterprise Geodatabase
Bug ID Number BUG-000094243
SubmittedFebruary 17, 2016
Last ModifiedAugust 22, 2025
Applies toArcSDE/Enterprise Geodatabase
Version found10.3.1
Version Fixed10.6.0
StatusFixed

Workaround

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

Steps to Reproduce

Bug ID: BUG-000094243

Software:

  • ArcSDE/Enterprise Geodatabase

Get notified when the status of a bug changes

Download the Esri Support App

Discover more on this topic

Esri Community

Search for related information

Training

Find training related to this topic

ArcGIS Ideas

Explore ideas and give feedback

Get help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options