Posts Tagged ‘ORA-39142’

ORA-39142: incompatible version number 5.1 in dump file

December 16th, 2019, posted in Oracle Queries
Share

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.ORA-39142 incompatible version number 5.1 in dump file,ORA-39142,incompatible version number 5.1,dump file,ORA 39142,incompatible version number,imam dba,dba imam,immam dba,dba immam,

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
Share