How to start tracing the Data Pump job

Please refer to Note 286496.1 Export/Import DataPump Parameter TRACE - How to Diagnose Oracle Data Pump.  Depending on how the Export or Import Data Pump job was started, there are several ways to activate tracing of the Data Pump processes.

Use the TRACE parameter upon the start of the job.

Start tracing by specifying the TRACE parameter and a trace level when the Export Data Pump or Import Data Pump is started. This is the standard way to activate Data Pump tracing.

Example:

expdp system/manager DIRECTORY=my_dir DUMPFILE=expdp_s.dmp LOGFILE=expdp_s.log TABLES=scott.emp TRACE=480300

Use the TRACE parameter when restarting a job.

If an Export or Import Data Pump  job was started without the TRACE parameter, it can be temporary stopped, and restarted with the TRACE parameter.

Example:

% expdp system/manager DIRECTORY=my_dir DUMPFILE=expdp_f.dmp LOGFILE=expdp_f.log TABLES=scott.emp TRACE=480300

-- press Control-C to go to the Interactive Command mode,

-- and temporarystop the job with the STOP_JOB command:

Export> stop

Are you sure you wish to stop this job ([yes]/no): yes

-- use the system generated job-name SYS_EXPORT_FULL_01 to re-attach to the job

-- and specify the TRACE parameter with a tracing level:

expdp system/manager ATTACH=sys_export_full_01 TRACE=480300

Export> status