Datapump NOT RUNNING & master table

Monitoring  the progress of data pump jobs, we discovered some old jobs that is no longer relevant.

 

SQL > set lines 100
SQL > col OWNER_NAME for a10
SQL > col JOB_NAME  for a21
SQL > col  OPERATION for a10
SQL > col JOB_MODE for a10 

SQL > SELECT
  2       owner_name
  3      ,job_name
  4      ,operation
  5      ,job_mode
  6      ,state
  7    FROM dba_datapump_jobs;

 

OWNER_NAME JOB_NAME              OPERATION  JOB_MODE   STATE
---------- --------------------- ---------- ---------- -----------
YOAV_B     SYS_EXPORT_FULL_01    EXPORT     FULL       NOT RUNNING

SYSTEM     FULL_EXPORT           EXPORT     FULL       NOT RUNNING

SYSTEM     SYS_EXPORT_SCHEMA_01  EXPORT     SCHEMA     NOT RUNNING

3 rows selected.

 

since the datapump job is stopped or killed and not needed any more, we decided to drop the master table

 

SQL > drop table YOAV_B.SYS_EXPORT_FULL_01 PURGE;

 

Table dropped.

 

SQL > SELECT
  2       owner_name
  3      ,job_name
  4      ,operation
  5      ,job_mode
  6      ,state
  7    FROM dba_datapump_jobs;

 

OWNER_NAME JOB_NAME              OPERATION  JOB_MODE   STATE
---------- --------------------- ---------- ---------- -----------

SYSTEM     FULL_EXPORT           EXPORT     FULL       NOT RUNNING

SYSTEM     SYS_EXPORT_SCHEMA_01  EXPORT     SCHEMA     NOT RUNNING