impdp system/*** directory=DATA_PUMP_DIR dumpfile=expdp_19c.dmp logfile=impdp_12.2.log
VERSION=12.0 Perform a direct import from 19c to 12.2 without an intermediate dump file : impdp system/*** directory=DATA_PUMP_DIR dumpfile=expdp_19c
Import: Release 12.2.0.1.0 ... ORA-39358: Export dump file version 19.0.0.0.0 not compatible with target version 12.2.0.0.0 5.1 ✅ Recommended Solution: Use VERSION parameter during export On the source (19c) , re-export the data with VERSION=12.2 (or VERSION=12.0 ): Problem Statement When migrating data from an Oracle
1. Report Overview | Attribute | Details | |---------------|-------------| | Error Code | ORA-39358 | | Full Message | ORA-39358: Export dump file version %s not compatible with target version %s | | Observed Scenario | Importing a dump file exported from Oracle 19.0.0.0.0 into Oracle 12.2.0 | | Severity | High (Import operation fails completely) | | Affected Tools | impdp (Data Pump Import), imp (legacy import for Data Pump files – not supported) | 2. Problem Statement When migrating data from an Oracle 19c database to an Oracle 12.2 database using Data Pump, the import operation terminates immediately with: the import operation terminates immediately with: