Posts Tagged ‘incompatible version number’

ORA-39142: incompatible version number 5.1 in dump file

December 16th, 2019, posted in Oracle Queries


Trying to export schema/tables from higher Database version and import to version, 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,


Import: Release - 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 - 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"


Please set parameter Version=12.1 in export command and import the data without issue.

Source Database ( :

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 ( :

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