Datapump (impdp) with Oracle in 12c PDB

Description

For Oracle 12c and Pluggable databases (PDB):

The default Data Pump directory object, DATA_PUMP_DIR, does not work with PDBs. You must define an explicit directory object within the PDB that you are exporting or importing:

Import: Release 12.1.0.1.0 - Production on Sat Aug 17 15:15:29 2013Copyright (c) 1982, 2013, Oracle and/or itsaffiliates. All rights reserved. Connected to: Oracle Database 12c Release 12.1.0.1.0 - 64bit Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name DATA_PUMP_DIR is invalid

Solution

Create a new directory and use this directory name:

SQL> create directory PDBORA121_DATA_PUMP_DIR as '/u01/app/oracle/admin/ora121/dpdump/';
SQL> grant read,write on directory PDBORA121_DATA_PUMP_DIR to system;

Edit the APPLY.sh and use this new directory name:

impdp SYSTEM/oracle@ora121_dbvlin702 table_exists_action=TRUNCATE network_link=ora112_dbvlin701
directory=PDBORA121_DATA_PUMP_DIR flashback_scn=5118129
tables=OE.CUSTOMERS,OE.INVENTORIES,OE.LOGON,OE.ORDERENTRY_METADATA,OE.ORDERS,OE.ORDER_ITEMS,OE.PRODUCT_DESCRIPTIONS,OE.PRODUCT_INFORMATION,OE.WAREHOUSES
logfile=OE_WAREHOUSES.log JOB_NAME=DP_ora112_121_0002

Arjen Visser August 17, 2013 22:45