Cancel datapump Jobs
First of all, use hand this handy query to checkout Datapump Job status.
SELECT owner_name, job_name, operation, job_mode, state FROM dba_datapump_jobs;
OWNER_NAME JOB_NAME OPERATION JOB_MODE STATE
---------- -------------------- ---------- ---------- ------------
SYSTEM EXP_FULL EXPORT FULL NOT RUNNING
