ORA-39142: incompatible version number 5.1 in dump file


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 – 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”


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


Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.