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

Comments

Popular posts from this blog

Fixing & Registering ORACLE_HOMES in Central Inventory

Export in Pl/Sql via DBMS_DATAPUMP