Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Clean-up dba_datapump_jobs

Clean-up dba_datapump_jobs

From: JAW <jwilliam_at_aglresources.com>
Date: Wed, 10 Oct 2007 09:56:52 -0700
Message-ID: <1192035412.541239.111600@o80g2000hse.googlegroups.com>


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.

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
Received on Wed Oct 10 2007 - 11:56:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US