Wednesday, August 24, 2011

Datapump export / Import to a Downward version

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