1.Purpose

This Frequently Asked Questions (FAQ) provides references to documents that deal with common Export Data Pump (expdp) and Import Data Pump (impdp) issues. These issues are dealt with in the following sections: Generic, Technical, Performance, Usage Tips, Replication, Oracle Applications, and NLS.
For references to documents dealing with the original Export (exp) and Import (imp) clients, see:
Note 175624.1 – Oracle Server – Export and Import FAQ

2.Questions and Answers

2.1.Generic

1. Which privileges are needed to run a Data Pump job?
   Note 351598.1 – Export/Import DataPump: The Minimum Requirements to Use Export DataPump and Import DataPump (System Privileges)

2. How to specify a directory that is used by Data Pump jobs?
   Note 266875.1 – Export/Import DataPump Parameter DIRECTORY – How to Specify a Directory

3. Which version should I use when moving data between different database releases?
   Note 553337.1 – Export/Import DataPump Parameter VERSION – Compatibility of Data Pump Between Different Oracle Versions
   Note 132904.1 – Compatibility Matrix for Export And Import Between Different Oracle Versions

2.2. Technical

1. How to view to content of a Data Pump dumpfile?
   Note 462488.1 – How to Gather the Header Information and the Content of an Export Dumpfile ?

2. How to trace Data Pump jobs and cleanup orphaned Data Pump jobs?
   Note 286496.1 – Export/Import DataPump Parameter TRACE – How to Diagnose Oracle Data Pump
   Note 336014.1 – How To Cleanup Orphaned DataPump Jobs In DBA_DATAPUMP_JOBS ?

3. How to enforce the method with which data is unloaded or loaded with Data Pump?
   Note 552424.1 – Export/Import DataPump Parameter ACCESS_METHOD – How to Enforce a Method of Loading and Unloading Data ?

2.3.Performance

1. How to speed up the performance of Data Pump?
   Note 453895.1 – Checklist for Slow Performance of Export Data Pump (expdp) and Import DataPump (impdp)
   Note 365459.1 – Parallel Capabilities of Oracle Data Pump

2. Which known issues may result in slower Data Pump performance?
   Note 453895.1 – Checklist for Slow Performance of Export Data Pump (expdp) and Import DataPump (impdp)
   Note 421441.1 – Datapump Import With dblink Going Slow With cursor_sharing Set to ‘force’
   Note 429846.1 – Slow Data Pump with REMAP_SCHEMA and REMAP_TABLESPACE parameters

2.4.Usage Tips

1. How to filter objects (like excluding tables or PL/SQL code) when running a Data Pump job?
   Note 341733.1 – Export/Import DataPump Parameters INCLUDE and EXCLUDE – How to Load and Unload Specific Objects

2. How to filter data (like exporting a subset of rows) when running a Data Pump job?
   Note 277010.1 – Export/Import DataPump Parameter QUERY – How to Specify a Query

3. How to export and import tables that reside in different schema’s?
   Note 277905.1 – Export/Import DataPump Parameter TABLES – How to Export and Import Tables Residing in Different Schemas

4. How to commit imported data during an Import Data Pump job?
   The parameter COMMIT=Y could be used with the original import client. Due to the difference in which data is loaded with Data Pump, there is no equivalent for the COMMIT parameter when loading data with Import Data Pump. See also:
   Note 552424.1 – Export/Import DataPump Parameter ACCESS_METHOD – How to Enforce a Method of Loading and Unloading Data ?

2.5.Replication

1. Why is data not propagated after an Import Data Pump job?
   Note 340789.1 – Import Datapump (Direct Path) Does Not Update Materialized View Logs

2.6.Oracle Applications

1. How to use Data Pump when migrating a database with Oracle Applications installed?
   Note 331221.1 – 10g Export/Import Process for Oracle Applications Release 10g
   Note 362205.1 – 10g Release 2 Export/Import Process for Oracle Applications Release 11i

2.7 NLS

7.1. How does NLS affect Export Data Pump and Import Data Pump jobs?
Note 227332.1 – NLS considerations in Import/Export – Frequently Asked Questions

3.References

NOTE:227332.1 – NLS considerations in Import/Export – Frequently Asked Questions
NOTE:266875.1 – Export/Import DataPump Parameter DIRECTORY – How to Specify a Directory
NOTE:277010.1 – Export/Import DataPump Parameter QUERY – How to Specify a Query
NOTE:277905.1 – Export/Import DataPump Parameter TABLES – How to Export and Import Tables Residing in Different Schemas
NOTE:286496.1 – Export/Import DataPump Parameter TRACE – How to Diagnose Oracle Data Pump
NOTE:331221.1 – 10g Export/Import Process for Oracle Applications Release 11i
NOTE:336014.1 – How To Cleanup Orphaned DataPump Jobs In DBA_DATAPUMP_JOBS ?
NOTE:340789.1 – Import Datapump (Direct Path) Does Not Update Materialized View Logs
NOTE:341733.1 – Export/Import DataPump Parameters INCLUDE and EXCLUDE – How to Load and Unload Specific Objects
NOTE:351598.1 – Export/Import DataPump: The Minimum Requirements to Use Export DataPump and Import DataPump (System Privileges)
NOTE:362205.1 – 10g Release 2 Export/Import Process for Oracle Applications Release 11i
NOTE:132904.1 – Compatibility Matrix for Export And Import Between Different Oracle Versions [Video]
NOTE:175624.1 – Oracle Server – Export and Import FAQ
NOTE:365459.1 – Parallel Capabilities of Oracle Data Pump
NOTE:421441.1 – DataPump Import Via NETWORK_LINK Is Slow With CURSOR_SHARING=FORCE
NOTE:429846.1 – Slow Data Pump with REMAP_SCHEMA and REMAP_TABLESPACE parameters
NOTE:453895.1 – Checklist For Slow Performance Of DataPump Export (expdp) And Import (impdp)
NOTE:462488.1 – How to Gather the Header Information and the Content of an Export Dumpfile ?
NOTE:552424.1 – Export/Import DataPump Parameter ACCESS_METHOD – How to Enforce a Method of Loading and Unloading Data ?
NOTE:553337.1 – Export/Import DataPump Parameter VERSION – Compatibility of Data Pump Between Different Oracle Versions
NOTE:786165.1 – Understanding the ESTIMATE and ESTIMATE_ONLY Parameters in Export DataPump