PROBLEM :
Trying to export schema/tables from higher Database version 12.2.0.1.0 and import to version 12.1.0.1.0, causing following error message.
ERROR :
Import: Release 12.1.0.2.0 - Production on Thu Jun 13 17:03:18 2019 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 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/expimp/schemas_name.dmp"
SOLUTION :
Please set parameter Version=12.1 in export command and import the data without issue.
Source Database (12.2.0.1) :
expdp system/****@prod schemas=schemas_name Version=12.1 directory=EXPDP dumpfile=schemas_name.dmp log=schemas_name.log expdp system/****@PROD directory=EXPDP tables=table_name Version=12.1dumpfile=schemas_name.dmp log=schemas_name.log
Target Database (12.1.0.1) :
impdp system/****@prod directory=EXPDP schemas=schemas_name dumpfile=schemas_name.dmp logfile=schemas_name.log impdp system/****@PROD directory=EXPDP tables=table_name dumpfile=schemas_name.dmp log=schemas_name.log
Comments
Tags: Database (12.1.0.1), Database (12.2.0.1), dump file, incompatible version number, incompatible version number 5.1, ORA-39142, ORA-39142: incompatible version number 5.1 in dump file