Tuesday, April 9, 2019

ORA-39142: incompatible version number 5.1 in dump file "/backup/dump/tab.dmp" while import

Reason : Oracle Version Incompatible.You are exporting data from 12.2 and importing into 11.2 database,then that time you are getting error ORA-39142.


Error Message:
Import: Release 11.2.0.4.0 - Production on Tue Apr 9 04:39:26 2019

Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management 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 "/backup/dump/tab.dmp"

Solution : While taking export use version=11.2 parameter on expdp command.Then import the dump into 11.2 database.

Output Logs:
Export Log:
expdp system tables=schema.tab directory=dpump_dir1 dumpfile=tab.dmp exclude=statistics exclude=TRIGGER exclude=REF_CONSTRAINT logfile=out.log version=11.2

Import Log:
impdp system TABLE_EXISTS_ACTION=REPLACE remap_tablespace=TEST_DATA:TAR_DATA remap_tablespace=TEST_INDX:TAR_INDX directory=dpumpdir dumpfile=tab.dmp logfile=out.log

No comments:

Post a Comment

How can I restore Cassandra snapshots?