ORA-39142: incompatible version number 3.1 in dump file "/amit/amit.dmp"

Few days ago I was trying to import some tables from one database to another through datapump utility and I faced below mentioned errors :-

bash-3.2$ impdp amit/amit directory=datapump dumpfile=EXPDP_AMIT_TABLES.DMP remap_schema=source:amit

Import: Release 11.1.0.7.0 - 64bit Production on Tuesday, 18 December, 2012 10:14:40

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 3.1 in dump file "/amit/amit.dmp"

When I searched regarding this error, I find out that I was trying to transfer data from a higher database version to a lower database version. PFB details of DB version's :-

Oracle Database 11g Enterprise edition Release 11.2.0.1.0 ----- Windows

Oracle Database 11g Enterprise edition Release 11.1.0.7.0 ------ Aix

This problem is not related to different platforms , its due to different version numbers

Solution :-

1. Export the required tables in the source database having higher version number by using version=11.1

2. Now import the required tables in target database and its completes without any errors.

Export :-

expdp amit/amit directory=datapump dumpfile=EXPDP_AMIT_TABLES.DMP logfile=EXPDP_AMIT_TABLES.log version=11.1 tables=A,B,C compression=all

Import :-

impdp amit/amit directory=datapump dumpfile=EXPDP_AMIT_TABLES.DMP remap_schema=source:amit 

It will import the tables without any error.

I hope this article helped you.

Regards,
Amit Rath