Difference between revisions of "Import Data Pump ORA-39142: incompatible version number"

From Ittichai Chammavanijakul's Wiki
Jump to navigation Jump to search
Line 26: Line 26:
  
 
Reference: http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_overview.htm#CEGFCFFI
 
Reference: http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_overview.htm#CEGFCFFI
 +
 +
[[Category:Oracle_FAQs]]

Revision as of 16:11, 8 March 2011

If you get this error when importing data pump (impdp):

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 3.1 in dump file "/project/exp/t.dmp

This is caused by the export file has a higher version than the version of the import tool.

You can specify VERSION when import data dump.

Per the help page of the expdp, here is the description.

VERSION               Version of objects to export where valid keywords are:
                      (COMPATIBLE), LATEST, or any valid database version.

Sample here is to expdp from 11.2 to import into 11.1.

$ expdp system directory=EXPDIRFA dumpfile=t.dmp version=11.1.0.0.0


Reference: http://download.oracle.com/docs/cd/B19306_01/server.102/b14215/dp_overview.htm#CEGFCFFI