Ways to clear stoped IMPDP/EXPDP job

The stoped IMPDP/EXPDP job will leave a record in dba_datapump_jobs that appears as not running.

There are two scenarios for clearing the stopped job:

1) Job can attach
If the job can be attach, you can attach and then kill the job.
such as: EXPDP system/**** attach=sys_export_table_01
Kill_job

2) job cannot be attach
If the job cannot be attach, you need to delete the master table under the user who is connecting datapump.
such as: Conn system/*****
drop table sys_export_table_01 (the master table name is typically the same as job name)
The user name and job name above can be obtained from dba_datapump_jobs.

Ways to clear stoped IMPDP/EXPDP job