HiveBrain v1.2.0
Get Started
← Back to all entries
snippetMinor

How to Import an Oracle dump version 5.1 into 12c?

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
dumpversioninto12choworacleimport

Problem

I have .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.

Context

StackExchange Database Administrators Q#241288, answer score: 4

Revisions (0)

No revisions yet.