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 ...

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: