Re: Replication refresh job fail

From: Daniel Navarro <the_navarros_at_worldnet.att.net>
Date: Thu, 08 Nov 2001 05:17:58 GMT
Message-ID: <aAoG7.177008$W8.5931446@bgtnsc04-news.ops.worldnet.att.net>

Not sure this is going to help, but try moving your updateable snapshots to their own tablespace. Or you could try moving them to their own refresh group.

-Dan N.

"george" <george_at_netinfo.com.cy> wrote in message news:f577a07.0111060259.d3af030_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. Can any one help me on this?
>
> *** 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
Received on Wed Nov 07 2001 - 23:17:58 CST