ORA-39142: incompatible version number 5.1 in dump file


Trying to export schema/tables from higher Database version and import to version, causing following error message.


Import: Release – Production on Wed Jun 20 05:22:35 2018

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 “xxx.dmp”


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

Source Database(

expdp scott/tiger@PRIM directory=DATAPUMP tables=scott.testtb Version=12.1 dumpfile=Exp_Scott_test.dmp logfile=Exp_Scott_test.log

Target Database(

impdp scott/tiger@TEST directory=DATAPUMP tables=scott.testtb dumpfile=Exp_Scott_test.dmp logfile=Imp_Scott.log

Thank you !!

Post a comment or leave a trackback: Trackback URL.


  • AVER  On September 19, 2018 at 3:46 am

    What if we cannot export again, do we have a way

  • qwe  On December 7, 2018 at 9:42 pm

    god bless you

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: