OraFAQ Forum: Replication » ora-04020: deadlock detected while trying to lock objext XX.MLOG$_YY

Home » Server Options » Replication » ora-04020: deadlock detected while trying to lock objext XX.MLOG$_YY_@MyDBLINK.US.ORACLE.COM

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-04020: deadlock detected while trying to lock objext XX.MLOG$_YY_@MyDBLINK.US.ORACLE.COM [message #138037]

Mon, 19 September 2005 09:20

FRosa
Messages: 2
Registered: September 2005
Location: Rome

Junior Member

Hi,
I have two DB (A=Master and B=Replication), I have created Snapshot Log on table of DB A and I have created the materialized view (snapshot) on DB B. I have also created the same user on both DB.
When I launch the Create command the snapshot table is correct and contains the exact number of rows.
When I execute the refresh command execute DBMS_SNAPSHOT.REFRESH("system.Snapshot_Name"); Oracle send the message:

ORA-12018: following error encountered during code generation for
"system"."SnapshotName".
ORA-04020: deadlock detected while trying to lock objext BB.MLOG$_YY@DBLink_On-BB
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 794
... Etc ...

Someone can help me ? Embarassed