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 ModifiedFebruary 23, 2024
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 help from ArcGIS experts

Contact technical support

Download the Esri Support App

Go to download options

Discover more on this topic