Stop the EXPDP/IMPDP datapump Job in Oracle

  • Check the job status

Select * from dba_datapump_jobs;

  • Note down the job name from output.
  • Attach the job as below.

expdp system/password attach=<jobname>

  • Check the job status 

expdp status

  • Stop or terminate the job.

Export> KILL_JOB
Are you sure you wish to stop this job ([yes]/no): yes
$>

  • Check the status from dba_datapump_jobs.

select * from dba_datapump_jobs;

Comments