Secure, easy, responsive, free. File sharing storage made simple!
ORA-39358: Export dump file version 19.0.0.0.0 not compatible with target version 12.2.0
The ORA-39358 error is Oracle’s way of enforcing a fundamental rule:
expdp user/password@source_db SCHEMAS=hr DIRECTORY=dpump_dir DUMPFILE=export_12_2.dmp VERSION=12.2 Use code with caution. Copied to clipboard Verify Target Compatibility: Before importing, ensure the COMPATIBLE parameter on your 12.2 database is actually set to (or higher) to accept the incoming file. Check with: SHOW PARAMETER COMPATIBLE; in SQL*Plus. ORA-39358: Export dump file version 19
impdp directory=DATA_PUMP_DIR dumpfile=your_dump_file.dmp sqlfile=check_version.sql
This should be a last resort. Many 19c objects will be skipped or result in errors. impdp directory=DATA_PUMP_DIR dumpfile=your_dump_file
If re-exporting is not an option, you must upgrade the target database's COMPATIBLE parameter or the entire database instance to match or exceed the dump file version.
( compatible_12_2.dmp ) to the 12.2 target server. ( compatible_12_2
expdp system/*** directory=DATA_PUMP_DIR \ dumpfile=expdp_for_12.2.dmp \ schemas=HR \ VERSION=12.2
We also provide support via WebDav protocol for Windows, Linux, MacOS, and Blackberry. Learn more
Get started now and enjoy the feeling of free storage while sharing what you love to your loved ones.
Get started