ORA-39001: invalid argument value ORA-39142: incompatible version number 5.1 in dump file

ORA- Error:


ORA-39001: invalid argument value

ORA-39000: bad dump file specification

ORA-39142: incompatible version number 5.1 in dump file " "


While importing a oracle dump file on 12c (12.1)  exported by 19c (19.0) in Linux using data pump  


Cause:


export dump taken on oracle 19c db Linux source is not compatible for import on lower oracle version 12c and below , causing error ORA-39142: incompatible version number 5.1 in dump file


Solution:


Use version to specify the lower version number where dump will be imported while taking backup using expdp on source (19c)


expdp directory=EXPDIR dumpfile=exp_tab01.dmp logfile=exp_tab01.log version=12.1


Supply appropriate version value incase version differs , it should fix the error ORA-39142 ORA-39001

No comments:

Post a Comment