How to stop export/import job in oracle

 This article explains how to stop export(expdp) or import(impdp) job in oracle database.

Let us assume that, we have an export job running in database. For some reason we have to cancel the running export job. Follow below steps to stop export/import job. 

Step 1. Find the job name which is running in the database using below query.

select JOB_NAME,state from dba_datapump_jobs;

20:45:45 SQL> select JOB_NAME,state from dba_datapump_jobs;

JOB_NAME                            STATE

----------------------------------------              ------------------------------

SYS_EXPORT_SCHEMA_01 EXECUTING

20:45:46 SQL> 

Step 2: Attach export job using below command.

[oracle@server1 EXPDP_DATA]$ expdp \"/ as sysdba\" attach=SYS_EXPORT_SCHEMA_01

Step 3: We can check the status of export using status command.

Step 4: Use KILL_JOB command to stop export/import process.

Step 5: We can able to see now the export job has been killed.

Thanks for going through this post............