killing expdp/impdp job.

some time it is really necessary  to terminate  a expdb/impdp jobs because of any valid reason which impact database.

here are the steps for quick references, how can we terminate the expdp/impdp job,

step 1:  take the job_name from below views
select * from USER_DATAPUMP_JOBS;
select * from DBA_DATAPUMP_SESSIONS;

step 2: Attach to that job_name which you find out in step1.

oracle@aa: /u02/backups # impdp system/***** attach=test_DUMP11(job_name)

step 3:  stop job immediate

impdp> STOP_JOB=IMMEDIATE
impdp>kill_job

- Manish Nashikkar