“ORA-08103: object no longer exists” durante EXPDP

[gazioliParticipante]

Opa! achei que tivesse esquecido de responder rs…

cara pelos waits enviado (2 query) se o SID for correspondente aos workers do expdp, vc esta com problema de Lock na Library.

olha só:

SID event time_waited SQL_TEXT
2300 library cache lock 3553 SELECT /+rule/ SYS_XMLGEN(V
1741 library cache lock 1741 SELECT /+all_rows/ SYS_XMLGEN(VALUE(K

use essa query abaixo para ver o que esta em lock library e o SID. (executar com SYS):

select distinct ses.ksusenum sid,
ses.ksuseser serial#,
ses.ksuudlna username,
ses.ksuseunm machine,
ob.kglnaown obj_owner,
ob.kglnaobj obj_name,
pn.kglpncnt pin_cnt,
pn.kglpnmod pin_mode,
pn.kglpnreq pin_req,
w.state,
w.event,
w.wait_Time,
w.seconds_in_Wait
from x$kglpn pn, x$kglob ob, x$ksuse ses, v$session_wait w
where pn.kglpnhdl in (select kglpnhdl from x$kglpn where kglpnreq > 0)
and ob.kglhdadr = pn.kglpnhdl
and pn.kglpnuse = ses.addr
and w.sid = ses.indx
order by seconds_in_wait desc;

---

Gazioli – OCA 11g