How to kill impdp job when unavailable !

Using the below query , we can find the not running job related with datapump :

SQL> select owner_name,job_name,state from dba_datapump_jobs;

OWNER_NAME JOB_NAME STATE
------------------------------ ------------------------------ ------------------------------
SYSTEM SYS_IMPORT_FULL_07 EXECUTING
SUPPORTDB BIN$umle+1gxgILgQ8CoAQyAgg==$0 NOT RUNNING
SYSTEM SYS_IMPORT_FULL_05 NOT RUNNING
SYSTEM SYS_IMPORT_FULL_06 NOT RUNNING
SYSTEM SYS_IMPORT_FULL_03 NOT RUNNING
SYSTEM SYS_IMPORT_FULL_04 NOT RUNNING
SYSTEM SYS_IMPORT_FULL_02 NOT RUNNING

7 rows selected.


we can drop it using below way :

SQL> DROP TABLE system.SYS_IMPORT_FULL_03 purge;

Table dropped.

SQL>