to find who locks else DBMS_REFRESH.REFRESH check locks on the snapshot
site:
select v$lock.sid, v$session.username, v$session.server, v$session.osuser,
v$session.machine, v$session.terminal,
trunc(id1/power(2,16)) RBS, bitand(id1,power(2,16)-1)+0 SLOT, id2 SQN,
v$lock.lmode, v$lock.request, v$lock.ctime
from v$lock, v$session
where v$lock.type = 'TX'
and v$lock.sid = v$session.sid
"Lasse Koskinen" <lasse.koskinen_at_fision.fi> ???????/???????? ? ????????
?????????: news:BAEFAB78.2D6E%lasse.koskinen_at_fision.fi...
> Hello,
>
> I am trying to use snapshots to replicate some tables from one Oracle 9
> database to another. I have created the environment as described in the
> manuals:
> 1. database link
> 2. snapshot logs at master site
> 3. actual snapshots with a select statement
> 4. refresh group
>
> Now when I try to do DBMS_REFRESH.REFRESH (or when the refresh group tries
> to run scheduled refresh) I get:
>
> ORA-12018: following error encountered during code generation for
> "XX"."YY".
> ORA-04020: deadlock detected while trying to lock objext XX.MLOG$_YY_at_ZZ
> ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
> ... Etc ...
>
> Any help is highly appreciated.
>
> Lasse
>
Received on Tue May 20 2003 - 03:08:48 CDT
