oracle11goracle12cdatapump

Oracle 12c datapump error when exporting from 11g database


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

I get following error

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

How do i fix this?


Solution

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