Oracle 12c datapump error while 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
- The database from which the schema should be exported is 11g (11.2.0.1.0)
- Datapump utility is set to 12c (12.1.0.1.0)
I am getting the following error
UDE-00018: Data Pump client is incompatible with database version 11.2.0.1.0
How to fix it?
source to share
As per Oracle Support recommendation 553337.1, you will need an 11.2 expdp client to export from the 11.2 source database. Wed 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 handle all versions of dump files:
"Import Data Pump can always read Export Data Pump file dump parameters created by older versions of the database.
source to share
If I understand correctly, you are exporting from Oracle 12c and importing to Oracle 11g. To do this, you need the VERSION
( Source ) parameter :
In your 12c instance (ignore 11g references):
C:\Users\Steve>expdp hr/hr TABLES=hr.employees2 VERSION=10.2 DIRECTORY=data_pump_dir DUMPFILE=emp2.dmp LOGFILE=emp2.log
Export: Release 11.2.0.1.0 - Production on Tue Sep 7 09:10:51 2010
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "HR"."SYS_EXPORT_TABLE_01": hr/******** TABLES=hr.employees2 VERSION=10.2 DIRECTORY=data_pump_dir DUMPFILE=emp2.dmp LOGFILE=emp2.log
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 64 KB
Processing object type TABLE_EXPORT/TABLE/TABLE
. . exported "HR"."EMPLOYEES2" 16.12 KB 107 rows
Master table "HR"."SYS_EXPORT_TABLE_01" successfully loaded/unloaded
******************************************************************************
Dump file set for HR.SYS_EXPORT_TABLE_01 is:
C:\APP\ORACLE\ADMIN\ORCL\DPDUMP\EMP2.DMP
Job "HR"."SYS_EXPORT_TABLE_01" successfully completed at 09:11:01
Then on your 11g instance (again, ignore 10g references):
C:\Users\Steve>impdp hr/hr TABLES=hr.employees2 DIRECTORY=data_pump_dir DUMPFILE=emp2.dmp LOGFILE=emp2_imp.log
Import: Release 10.2.0.1.0 - Production on Tuesday, 07 September, 2010 9:25:53
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Master table "HR"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "HR"."SYS_IMPORT_TABLE_01": hr/******** TABLES=hr.employees2 DIRECTORY=data_pump_dir DUMPFILE=emp2.dmp LOGFILE=emp2_imp.log
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "HR"."EMPLOYEES2" 16.12 KB 107 rows
Job "HR"."SYS_IMPORT_TABLE_01" successfully completed at 09:26:05
source to share
Data can be easily exported from 11g using the 12c expdp utility if you have a db link between 12c and 11g DB (in which case you are connecting to 12c db). Here's a simple example:
expdp user/password@host/service schemas=sample_schema network_link=link_to_11g directory=tmp dumpfile=sample_schema.dmp logfile=blabla.log
source to share