Wednesday, November 03, 2010

Killing A Datapump Job

If you need to kill a datapump import or export job (impdp/expdp), it is not sufficient to just kill the operating system process.

The oracle job will still be pending. It can be stopped by using the PL/SQL API or the impdp/expdp utilities.

Here is an example of how to attach to the job and stop it immediately.

expdp 'userid="/ as sysdba"' attach=<NAME_OF_JOB>
Export> stop_job=immediate
Are you sure you wish to stop this job ([y]/n): y

Here's how to find running impdp/expdp jobs:

select *
from dba_datapump_jobs

No comments: