Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

state is UNDEFINED dba_datapump_jobs

Prakash_dbaDec 16 2013 — edited Dec 16 2013

Hi,

oracle version : 10.2.0.5

i am unable to find export master table

PINDB> select
   o.status,
   o.object_id,
  2    3    4     o.object_type,
   o.owner||'.'||object_name "OWNER.OBJECT"
  5    6  from
  7     dba_objects o,
   dba_datapump_jobs j
where
  8    9   10     o.owner=j.owner_name
and
11   12     o.object_name=j.job_name
and
13   14     j.job_name not like 'BIN$%'
15  order by 4, 2;

no rows selected

but the below  query says the export state is undefined

PINDB> select * from dba_datapump_jobs;

OWNER_NAME                     JOB_NAME                       OPERATION                      JOB_MODE
------------------------------ ------------------------------ ------------------------------ ------------------------------
STATE                              DEGREE ATTACHED_SESSIONS DATAPUMP_SESSIONS
------------------------------ ---------- ----------------- -----------------
SYS                            SYS_EXPORT_FULL_01             EXPORT                         FULL
UNDEFINED                               0                 1                 2

and from os level i am unable to see any export backup

PINDB> !

youtele:/home/oracle=> ps -ef | grep export

  oracle 12954 12902  0 15:09:53 pts/4     0:00 grep export

Please can you help me to clean up this job

Thanks

PGR

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 13 2014
Added on Dec 16 2013
10 comments
3,811 views