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