Ora-39358 Export Dump File Version 19.0.0.0.0 Not Compatible With Target Version 12.2.0 < Latest — 2027 >

impdp system/*** directory=DATA_PUMP_DIR dumpfile=expdp_19c.dmp logfile=impdp_12.2.log

expdp system/*** directory=DATA_PUMP_DIR dumpfile=expdp_19c.dmp logfile=expdp_19c.log schemas=HR impdp system/*** directory=DATA_PUMP_DIR dumpfile=expdp_19c

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: impdp system/*** directory=DATA_PUMP_DIR dumpfile=expdp_19c

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

-- On 19c source expdp hr/hr@source_19c \ DIRECTORY=dp_dir \ DUMPFILE=hr_12_2_compat.dmp \ SCHEMAS=hr \ VERSION=12.2 \ LOGFILE=exp_hr.log