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:
Post a Comment