If you are migrating in between Upper to Lower version of Oracle database using DATAPUMP then you may runinto below error.
For my case, I was trying to export from 11.2.0.2 to 11.1.0.6
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 3.1 in dump file "/datapump/scott.dmp"
Solution is to specify the VERSION of target Database on datapump export parameter. And then import using regular command.
Example of using VERSION inside datapump command:
expdp system/******* VERSION=11.1.0.0.0 SCHEMAS=SCOTT directory=DATAPUMP dumpfile=SCOTT.dmp logfile=SCOTT_exp.log
No comments:
Post a Comment