Re: 8i server/8i lite replication

Babypuke

Do you have the capability to add calls to REPLICATION_OFF and REPLICATION_ON procedures? Of course, there is a slight problem here in that it's suggested that you need to suspend replication activity for all master groups in your replicated environment before setting this flag. I don't have two databases at the moment to play with to see if this is really a necessity or just a recommendation.

Pete

babypuke_at_my-deja.com wrote:

> question about replication (fast refresh) behavior:
>
> consider a single-master replication system where the server is 8.1.5
> on solaris. there are various oracle lite (8i) snapshot sites that
> perform fast refreshes to retrieve updates from the server.
>
> the problem: the server is also updated nightly by an external data
> source, with feeds that are NOT incremental. this data is fed into the
> server by a separate procedure (not by replication). the proc
> typically updates ALL the rows in the server tables. what ends up
> happening is that this procedure might have to set all the columns in a
> server table to themselves (i.e., no change), since the new data feed
> from the external source looks exactly like it did the day before.
>
> this, of course, is still considered an 'update' by replication, the
> MLOG$_xxx get filled up, and the snapshot sites end up replicating the
> entire table even though nothing's changed and it's doing what it
> thinks is a fast refresh.
>
> any ideas for a workaround? it's difficult to change the server update
> procedure. impossible to change the external source.
>
> thanks in advance ..
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

Received on Wed Nov 03 1999 - 10:23:58 CST