LOCATE ALL RUNNING DATAPUMP JOBS IN ORACLE DATABASE

-- locate Data Pump jobs:

SET lines 200

COL owner_name FORMAT a10;

COL job_name FORMAT a20

COL state FORMAT a12

COL operation LIKE state

COL job_mode LIKE state

SELECT owner_name, job_name, operation, job_mode,

state, attached_sessions

FROM dba_datapump_jobs

WHERE job_name NOT LIKE 'BIN$%'

and state='NOT RUNNING'

ORDER BY 1,2;

spool off ;