Path: text.usenetserver.com!out02a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!o80g2000hse.googlegroups.com!not-for-mail From: JAW Newsgroups: comp.databases.oracle.server Subject: Clean-up dba_datapump_jobs Date: Wed, 10 Oct 2007 09:56:52 -0700 Organization: http://groups.google.com Lines: 35 Message-ID: <1192035412.541239.111600@o80g2000hse.googlegroups.com> NNTP-Posting-Host: 65.243.68.237 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1192035412 1517 127.0.0.1 (10 Oct 2007 16:56:52 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 10 Oct 2007 16:56:52 +0000 (UTC) User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; InfoPath.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: o80g2000hse.googlegroups.com; posting-host=65.243.68.237; posting-account=ps2QrAMAAAA6_jCuRt2JEIpn5Otqf_w0 Xref: usenetserver.com comp.databases.oracle.server:436180 X-Received-Date: Wed, 10 Oct 2007 12:56:52 EDT (text.usenetserver.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. ---------------------------- ------------------------------ 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