Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
This error is received when trying to import a Data Pump export of the 12c r2 database to a lower version.
The error content is as follows.
1 2 3 | ORA-39001: invalid argument value ORA-39000: bad dump file specification ORA-39142: incompatible version number 5.1 in dump file "/u01/export/ORCL.DMP" |
In order not to receive this error, the database version to be imported must be specified with the VERSION parameter in the expdp command.
Below are the version values of the databases.
- VERSION=10.1 for 10.1.0.x
- VERSION=10.2 for 10.2.0.x
- VERSION=11.1 for 11.1.0.x
- VERSION=11.2 for 11.2.0.x
- VERSION=12.1 for 12.1.0.x
Example
1 | expdp system/****** directory=DATA_PUMP_DIR dumpfile=ORCL%U.dmp logfile=orcl_exp.log full=Y cluster=N version=11.2 |
