Monday, December 14, 2009

DataPump Incompatible version number 2.1 in Dump File

Recently did a migration task of some data from 11.1.0.6 to 10.2.0.4 using DataPump and hit this specific error "ORA-39142: incompatible version number 2.1 in dump file" during import process.

This means that the exported version was higher and the imported version cannot understand it.
So the import dump cannot be used any more in 10.2.0.4 , workaround to redo the export process with the option "version=10.2" to the expdp command.

What about when you cannot request another dump , may be the other source is a partner and they bill you for additional effort ?
Yes you can still get it done , by creating a local 11.1.0.6 dummy environment and then importing the dump into it. Now you have the dump inside a 11g environment , export it from the dummy environment with the option "version=10.2" and try importing into the 10.2.0.4 environment.

It worked for me and I hope this help.

Popular Posts