Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, June 14, 2011

kill Data pump job - data pump job status

if you are running the expdp job running in the foreground, then use ctrl ^c

ctrl ^c
Export> STOP_JOB=IMMEDIATE
Are you sure you wish to stop this job ([yes]/no): yes


or use
kill_job

also u can check the job status from the DB as below:

SELECT owner_name, job_name, operation, job_mode,state, attached_sessions FROM dba_datapump_jobs

once you find the job_name use the below to stop the job:


exec DBMS_DATAPUMP.STOP_JOB ( );
ex:

SQL> DECLARE
   var99 NUMBER;
BEGIN
    var99 := DBMS_DATAPUMP.ATTACH('SYS_EXPORT_FULL_02','SYS');
    DBMS_DATAPUMP.STOP_JOB (var99,1,0);
    END;
    /

PL/SQL procedure successfully completed.

No comments: