When you import or export using data pump impdp or expdp tools, the import/export is done by a job. You have an option to provide a job name using JOB_NAME parameter too
Following sql will give you the list of data pump jobs
select * from dba_datapump_jobs
If you want to kill your impdp or expdp
1) Make sure that your impdp/expdp command prompt window is active
2) Press Control-C , It will pause the job. Don't press another Control-C or close the command prompt. This will just close the window, but the job will still be running in the background
3) Type Kill_Job
ex: Import>kill_job
Are you sure you wish to stop this job (y/n): y
If by mistake, you closed the window and your import/export job is still running,
1) Get the name of the job using
select * from dba_datapump_jobs
2) Open a new command prompt window. If you want to kill your import job type
impdp username/password@database attach=name_of_the_job
3) Once you are attached to job, Type Kill_Job
ex: Import>kill_job
Are you sure you wish to stop this job (y/n): y
And your job is killed, it will no longer show in dba_datapump_jobs
very helpful, simple, and to the point. Thank you.
ReplyDeletegreat post. thanks . i needed this process to kill the job. i couldn't figure the job name out.
ReplyDeleteFranklin/Jason
FranklinFaces.com
Thanks a lot, it work so well. I really appreciate,
ReplyDeletesince I use regular kill the PID ,
and then stuck with this big datapump job.
D.L.
Didn't work for me... had closed window, when trying to get in w/new window, get the following:
ReplyDeleteORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31640: unable to open dump file 'xxxxx'
ORA-27037: unable to obtain file status
HP-UX Error: 2: No such file or directory
Additional information: 3
gud one, helped me a lot. thanks.
ReplyDeleteExcellent Post Man.. Saved my Day... I owe you a Party... Cheers!!!!
ReplyDeleteAshish
really helped me
ReplyDeletea very useful tip, thanks a lot
ReplyDeleteGracias, thanks, very useful
ReplyDeletehow do we kill all the jobs in state = "NOT RUNNING"
ReplyDeletei have around 100 jobs in that state, how to clear them ?
for the jobs with state = "NOT RUNNING", just drop the master job table in JOB_NAME
DeleteExample: drop table SYS_EXPORT_SCHEMA_01 purge;
Thanks ,
Deleteit's simple and to the point .
Thanks, good one.
ReplyDeleteThanks, its really good. Short and simple.
ReplyDeleteGood Article. Thanks.
ReplyDeleteThanks, very helpfull!
ReplyDelete