Day: February 14, 2022

ORA-39142: incompatible version number 4.2 in dump file

The following errors occur when running impdp on same database version 12.1.0.2 as the source database:

ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-39142: incompatible version number 4.2 in dump file "/tmp/exp_tables.dmp"

SOLUTION

  • Apply patches to the same patch level for both source and target database.

OR

  • Use parameter VERSION.
$ expdp  ... VERSION=12.1 ...
Advertisement