Data Pump Export Monitoring

Export Monitoring

While Data Pump Export (DPE) is running, press Control-C; it will stop the display of the messages on the screen, but not the export process itself. Instead, it will display the DPE prompt as shown below. The process is now said to be in "interactive" mode:

Export>

This approach allows several commands to be entered on that DPE job. To find a summary, use the STATUS command at the prompt:

Export> status
Job: CASES_EXPORT
 Operation: EXPORT                        
 Mode: TABLE                         
 State: EXECUTING                     
 Degree: 1
 Job Error Count: 0
 Dump file:  /u02/dpdata1/expCASES.dmp
     bytes written =  2048

Worker 1 Status:
 State: EXECUTING                     
 Object Schema: DWOWNER
 Object Name: CASES
 Object Type: TABLE_EXPORT/TBL_TABLE_DATA/TABLE/TABLE_DATA
 Completed Objects: 1
 Total Objects: 1
 Completed Rows: 4687818

Remember, this is merely the status display. The export is working in the background. To continue to see the messages on the screen, use the command CONTINUE_CLIENT from the Export> prompt.