snippetMinor
How to Import an Oracle dump version 5.1 into 12c?
Viewed 0 times
dumpversioninto12choworacleimport
Problem
I have
This is the error I get:
What can I do?
.dmp files exported as version 5.1 and I need to import them on an Oracle 12c. I have no access to the original database to re-export setting the VERSION parameter. This is the error I get:
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 5.1 in dump file "/media/sf_Data
/DUMP_MS/mydumfile.dmp"What can I do?
Solution
Of course Oracle did not make this information public, but if you can access MOS, then go ahead:
Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions (Doc ID 553337.1)
12.1 uses dump file sets of version 4.1. 12.2 uses dump file sets of version 5.1
You can not import a dump file created in 12.2 to 12.1, unless the VERSION parameter was specified to allow lower versions to import it.
You will need at least a 12.2 version database to import that dumpfile.
Export/Import DataPump Parameter VERSION - Compatibility of Data Pump Between Different Oracle Versions (Doc ID 553337.1)
12.1 uses dump file sets of version 4.1. 12.2 uses dump file sets of version 5.1
You can not import a dump file created in 12.2 to 12.1, unless the VERSION parameter was specified to allow lower versions to import it.
You will need at least a 12.2 version database to import that dumpfile.
Context
StackExchange Database Administrators Q#241288, answer score: 4
Revisions (0)
No revisions yet.