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