Basic replication + fast refresh -> deadlock on snapshot log

From: Lasse Koskinen <lasse.koskinen_at_fision.fi>
Date: Tue, 20 May 2003 09:52:56 +0300
Message-ID: <BAEFAB78.2D6E%lasse.koskinen@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 - 01:52:56 CDT