Oracle datapump status

During a import run of a +100GB Oracle database I was curious what the current progress was. I discovered you can press Ctrl+C to go to an interactive command mode during a import of export using datapump (impdp of expdp). In the interactive you can request the current status of the job(s). It is also possible to stop, start and resume jobs. For all options just type ‘HELP’. See the example below:

Import> status Job: SYS_IMPORT_FULL_02 Operation: IMPORT Mode: FULL State: EXECUTING Bytes Processed: 0 Current Parallelism: 1 Job Error Count: 0 Dump File: /usr/local/oracle/import/a01act-20140811-%u.dmp Dump File: /usr/local/oracle/import/a01act-20140811-01.dmp Dump File: /usr/local/oracle/import/a01act-20140811-02.dmp Dump File: /usr/local/oracle/import/a01act-20140811-50.dmp Dump File: /usr/local/oracle/import/a01act-20140811-51.dmp Worker 1 Status: Process Name: DW00 State: EXECUTING Object Schema: **** Object Name: PTL***** Object Type: SCHEMA_EXPORT/TABLE/TABLE_DATA Completed Objects: 1 Completed Rows: 122,772 Completed Bytes: 102,619,789,192 Percent Done: 49 Worker Parallelism: 1 Import>

So I’m almost halfway now.

To return to the logging mode:

Import> CONTINUE_CLIENT