you may run into situations where you need to stop an expdp or impdp job from running. killing the datapump process from the Operating System level won’t stop the job , infact if you use the below query you may still see it in “RUNNING” state.
SQL> select * from dba_datapump_jobs;
SOOOOOO you need to kill the datapump job from database-level as follows:
$ORACLE_HOME/bin/expdp “‘/as sysdba'” attach=SYS.”‘EXPORT_TABLE_NAME‘”
Are you sure you wish to stop this job ([yes]/no): yes
Check it again :
select job_name,owner_name,state from dba_datapump_jobs;
Remark: EXPORT_TABLE_NAME is the table name resulted in the query unser SYS account.