About Me

My photo
Bangalore, India
I am an Oracle Certified Professional working in SAP Labs. Everything written on my blog has been tested on my local environment, Please test before implementing or running in production. You can contact me at amit.rath0708@gmail.com.

Tuesday, December 18, 2012

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

4 comments: