My Oracle Support Banner

Export/Import DataPump Parameter TRACE - How to Diagnose Oracle Data Pump (Doc ID 286496.1)

Last updated on JUNE 13, 2023

Applies to:

Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version to [Release 10.1 to 11.2]
Oracle Database Cloud Schema Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.


This document describes how to use the TRACE parameter with the Export Data Pump (expdp) and Import Data Pump (impdp) database utilities when diagnosing incorrect behavior and/or troubleshooting Data Pump errors.


The article is intended for users of the database utilities Export Data Pump (expdp) and Import Data Pump (impdp), and who need to troubleshoot the execution of the jobs that are generated by these utilities. These database utilities were introduced with Oracle10g. The article gives detailed information how to use the undocumented parameter TRACE.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
 1. Introduction.
 2. How to create a Data Pump trace file ?  Parameter: TRACE
 3. How to start tracing the Data Pump job ?
 4. How are Data Pump trace files named, and where to find them ?
 5. How to get a detailed status report of a Data Pump job ?  Parameter: STATUS
 6. How to get timing details on processed objects ? Parameter: METRICS
 7. How to get SQL trace files of the Data Pump processes ?
 8. How to get header details of Export Data Pump dumpfiles ?
 9. How to get Data Definition Language (DDL) statements ? Parameter: SQLFILE
 10. How to get the DDL both as SQL statements and as XML data ?
 Additional Resources

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.