Ora-39126 Worker Unexpected Fatal Error In Kupw-worker.prepare-data-imp 71 (Authentic ✮)

impdp directory=DATA_PUMP_DIR dumpfile=your.dmp \
  transform=segment_attributes:n:lob_storage:n \
  exclude=statistics \
  parallel=1 \
  logfile=test.log

If the error persists, the dump file is likely irrecoverably corrupted, and you will need to recreate it from the source.

If Data Pump consistently fails, try the original imp utility (if export was done with original exp).

The error code 71 is historically linked to spatial index or geometry validation issues. If your dump contains SDO_GEOMETRY columns and the target lacks Spatial components or has corrupted metadata, this error arises.

# Use DBMS_DATAPUMP to validate
impdp user/pwd DIRECTORY=dp_dir DUMPFILE=exp.dmp SQLFILE=check.sql

If validation fails, re-export the source data.

Look for the table name in the error context or use:

-- Query Data Pump master table if import was running
SELECT object_name, object_type, status, error_count
FROM "<schema>"."<job_name>_MASTER"
WHERE status = 'ERROR';

Sometimes reducing or increasing PARALLEL helps:

impdp ... PARALLEL=1   # or match CPU cores

When importing into a target table with a different definition than the source: