Re: two snapshots for the same master table

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Fri, 15 Nov 2002 09:48:39 +1000
Message-ID: <3yVA9.76618$g9.216442@newsfeeds.bigpond.com>

Hi Rx,

You most certainly can create two snapshots (or materialized views) for the same master table.

Are you sure that the second snapshot has been configured correctly for refreshing ? Are you sure the snapshot log contains all the necessary columns for the second snapshot ? Note you only need the one snapshot log per master table but it must contain all the necessary columns for all your dependent fast refresh snapshots.

Good Luck

Richard
"Rx" <rx20010101_at_yahoo.com> wrote in message news:468aa31a.0211141004.58c62e36_at_posting.google.com...
> Is this possible? I want to create two snapshots (at two different
> snapshot sites) for the same master table at one master site. Looks
> like Oracle replication allows that, but only the "first" snapshot
> (the one created first) gets refreshed, and the second one doesn't.
> Maybe this is because there can be only one snapshot log, and
> therefore only one series of refresh events can be handled. Is there a
> way to work around this? Thanks.
Received on Thu Nov 14 2002 - 17:48:39 CST