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>
