Re: Clean-up dba_datapump_jobs

From: bdbafh <bdbafh_at_gmail.com>
Date: Wed, 10 Oct 2007 18:06:32 -0000
Message-ID: <1192039592.752339.298920@57g2000hsv.googlegroups.com>

JAW wrote:
> I have two export jobs that don't have any sessions attached to them.
>
> I would like to get these two jobs out of dba_datapump_jobs
>
> I don't see anything at the moment.
>
> ---------------------------- ------------------------------
> STATE DEGREE ATTACHED_SESSIONS
> DATAPUMP_SESSIONS
> ------------------------------ ---------- -----------------
> -----------------
> OPS$ORACLE JAKE_RESTORE
> IMPORT SCHEMA
> EXECUTING 10
> 1 12
>
> OPS$ORACLE SYS_EXPORT_SCHEMA_01
> EXPORT SCHEMA
> NOT RUNNING 0
> 0 0
>
> OWNER_NAME JOB_NAME
> ------------------------------ ------------------------------
> OPERATION JOB_MODE
> ------------------------------ ------------------------------
> STATE DEGREE ATTACHED_SESSIONS
> DATAPUMP_SESSIONS
> ------------------------------ ---------- -----------------
> -----------------
>
> OPS$ORACLE SYS_EXPORT_SCHEMA_02
> EXPORT SCHEMA
> NOT RUNNING 0
> 0 0

  1 select 'DROP TABLE '||owner||'.'||table_name||';'   2 from dba_tables
  3* where table_name like '%SYS%EXPORT%' SQL> /
 'DROPTABLE'||OWNER||'.'||TABLE_NAME||';'

---

DROP TABLE SYSTEM.SYS_EXPORT_FULL_01; SQL> DROP TABLE SYSTEM.SYS_EXPORT_FULL_01; Table dropped.

You might want to drop it with the purge option or purge the recyclebin manually.

-bdbafh Received on Wed Oct 10 2007 - 13:06:32 CDT