Error:
Experienced the below error during the import of the export dump file to the Oracle 12.1.
Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 – 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 5.1 in dump file “/u01/app/oracle/admin/koms/dpdump/sms_tables.dmp”
Solution:
The export backup taken from 12.2 is not supported by default to be imported to the version 12.1, during the export from the oracle 12.2 supply the version=12.1 will resolve the error during the import to the oracle 12.1.
$expdp system tables=sms.transaction_log, sms.additional_trx_log dumpfile=sms_tables.dmp logfile=sms_tables.log version=12.1 reuse_dumpfiles=true