Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Clean-up dba_datapump_jobs
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_NAMEDATAPUMP_SESSIONS
------------------------------ ------------------------------
OPERATION JOB_MODE
------------------------------ ------------------------------
STATE DEGREE ATTACHED_SESSIONS
OPS$ORACLE SYS_EXPORT_SCHEMA_02 EXPORT SCHEMA NOT RUNNING 0 0 0Received on Wed Oct 10 2007 - 11:56:52 CDT
![]() |
![]() |