Re: Replication Problem Solaris/Oracle7.3.4 HPUX10.20 8.0.5.1

From: Helen Macduff <Helen.Ward_at_alcatel.com.au>
Date: Wed, 20 Oct 1999 15:30:44 +1000
Message-ID: <380D5384.306E7DF6@alcatel.com.au>

Yes the logs exist on the master site and I have created a refresh group. All this works file in developement and test but not in production.

A complete refresh fails unless I convert it from a simple to a complex by adding a 'do nothing' where clause.

A fast refresh works from the production to another 7.3.4 Site. But not to a 8.0.5

I am in Sydney Australia

Joe Moore wrote:
>
> Helen
>
> Have you created Snapshot Logs on all Master Site Tables?
>
> If you are using FAST REFRESH mode, as opposed to COMPLETE Refresh mode, you
> will need to create SNAPSHOT LOGS on all Master Site tables first, BEFORE
> you create any Snapshots on tables.
>
> Also you may want to assign all related snapshots to a REFRESH GROUP, to
> help synchronise your replication for a related group of tables for
> referential integrity, transaction consistency etc., and when setting up
> Refresh Intervals for AUTOMATIC Refreshes.
>
> For further info - read Chapter 2 Using Basic Replication in Replication
> book of Online Oracle8 Documentation Library.
>
Received on Wed Oct 20 1999 - 00:30:44 CDT