Monday, February 27, 2012

How to kill data Pump Job


Import> STOP_JOB=IMMEDIATE

or

Export>STOP_JOB=IMMEDIATE

also u can use this script

DECLARE
job_1 NUMBER;
BEGIN
job_1 := DBMS_DATAPUMP.ATTACH('JOB_NAME','SYSTEM');
DBMS_DATAPUMP.STOP_JOB (job_1,1,0);
END;

No comments:

Post a Comment