Oracle 12c datapump error when exporting from 11g database

Question

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 1

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