Oracle 12c datapump error when exporting from 11g database

oracle11g oracle12c datapump
Varun Rao picture Varun Rao · Jun 25, 2015 · Viewed 42.3k times · Source

I am using the following in cmd.

expdp system/*****@11.11.1.11:1521/orcl schemas=HR directory=DATADIR
dumpfile=HR_20150625.dmp logfile=HR_20150625.log version=11.2
  • The database from which schema is to be exported is 11g (11.2.0.1.0)
  • The datapump utility is of 12c (12.1.0.1.0)

I get following error

UDE-00018: Data Pump client is incompatible with database version 11.2.0.1.0

How do i fix this?

Answer

Friedrich picture Friedrich · Aug 25, 2015

According to My Oracle Support Note 553337.1 you'll need an 11.2 expdp client to do the export from an 11.2 source database. Cf. this matrix:

Export Data   Connecting to Source Database:
Pump client      10gR1      10gR2      11gR1      11gR2      12cR1
    version   10.1.0.x   10.2.0.x   11.1.0.x   11.2.0.x   12.1.0.x
----------- ---------- ---------- ---------- ---------- ----------
   10.1.0.x  supported  supported  supported  supported  supported
   10.2.0.x         no  supported  supported  supported  supported
   11.1.0.x         no         no  supported  supported  supported
   11.2.0.x         no         no         no  supported  supported
   12.1.0.x         no         no         no         no  supported

12c impdp can process all dump file versions:

"Import Data Pump can always read Export Data Pump dumpfile sets created by older versions of the database."

Related questions

Oracle Joins - Comparison between conventional syntax VS ANSI Syntax

Preamble Of late, I see too many geeks commenting on Oracle questions saying that "Do not use (+) operator, rather use JOIN syntax". Question I do see that both work well. But what is the real difference between using them and …

Read More
ORA-28040: No matching authentication protocol : Oracle 12c Upgrade

We have migrated our Oracle database to 12c from 11g. We have a legacy application running in Java 1.5 and using ojdbc14.jar. Our application is not able to create connection to database error saying : java.sql.SQLException: ORA-28040: No matching …

Read More
Setting up the Oracle database on Macbook Pro (OS X Yosemite)

I see that Oracle 11g or 12c doesn't have the download files for OS X. However, there is a version of the SQL Developer available for OS X. What's the point of the SQL Developer when you don't have a …

Read More