killing expdp/impdp job


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

select * from DBA_DATAPUMP_SESSIONS;
step 2: try to 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

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: