Monday, November 16, 2015

Kill, restart or resume datapump expdp/impdp jobs

Find datapump jobs


SELECT owner_name, job_name, operation, job_mode, 

state, attached_sessions 

FROM dba_datapump_jobs 

WHERE job_name NOT LIKE 'BIN$%' 

ORDER BY 1,2






  Killing or stopping datapump jobs

The difference between Kill and Stop is simple to explain. When killing a job, you won’t be able to resume or start it again. Also logs and dumpfiles will be removed!
When exporting (or importing), press Ctrl-c to show the datapump prompt and type KILL_JOB orSTOP_JOB[=IMMEDIATE]. You will be prompted to confirm if you are sure.
Adding ‘=IMMEDIATE‘ to STOP_JOB will not finish currently running ‘sub-job’ and must be redone when starting it again.
Processing object type DATABASE_EXPORT/SCHEMA/TABLE/TABLE_DATA
[Ctrl-c]
Export> KILL_JOB
..or..
Export> STOP_JOB=IMMEDIATE
Are you sure you wish to stop this job ([yes]/no): yes

Resuming a stopped job

Identify your job using above query
> expdp system ATTACH=SYS_EXPORT_SCHEMA_01

Start/restart the job with START_JOB, use ‘=SKIP_CURRENT‘ if you want to skip

the current job. To show progress again, type CONTINUE_CLIENT (Job will be restarted if idle).


Export> START_JOB[=SKIP_CURRENT]
Export> CONTINUE_CLIENT

No comments:

Post a Comment