How to kill the expdp jobs from backend.

1. First check what datapump jobs are running:


SQL> select * from dba_datapump_jobs;
OWNER_NAME  JOB_NAME              OPERATION   JOB_MODE   STATE      DEGREE ATTACHED_SESSIONS
------------------------------ ------------------------------ ------------------------------
SYSTEM      SYS_EXPORT_FULL_01    EXPORT        FULL   EXECUTING     32         1



2. To stop/kill the datapump job, login as sysdba and execute from sqlplus:


DECLARE
   h1 NUMBER;
BEGIN
   h1 := DBMS_DATAPUMP.ATTACH('JOB_NAME','OWNER_NAME');
   DBMS_DATAPUMP.STOP_JOB (h1,1,0);
END;
/

for example:

DECLARE
   h1 NUMBER;
BEGIN
   h1 := DBMS_DATAPUMP.ATTACH('SYS_EXPORT_FULL_01','SYSTEM');
   DBMS_DATAPUMP.STOP_JOB (h1,1,0);
END;
/


3. After stopping the datapump job, oracle removes and the dmp files that already have been produced. Check again:


SQL> select * from dba_datapump_jobs;
Reviews