Replication refresh job failure

From: george <george_at_netinfo.com.cy>
Date: 7 Nov 2001 00:10:19 -0800
Message-ID: <f577a07.0111070010.187b3565_at_posting.google.com>


Hi,

I have an updatable snapshot database replicated to a master one. The replication seems to work OK (most of the time at least!) but once a while I'm receiving the following error. I'll appriciate any help.

  • SESSION ID:(28.23960) 2001-11-05 20:22:55.312
  • 2001-11-05 20:22:55.312 ORA-12012: error on auto execute of job 22 ORA-23402: refresh was aborted because of conflicts caused by deferred txns ORA-06512: at "SYS.DBMS_SNAPSHOT", line 617 ORA-06512: at "SYS.DBMS_SNAPSHOT", line 674 ORA-06512: at "SYS.DBMS_IREFRESH", line 577 ORA-06512: at "SYS.DBMS_REFRESH", line 211 ORA-06512: at line 1

Thx Received on Wed Nov 07 2001 - 09:10:19 CET

Original text of this message