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