Re: Dependent snapshot execution?

From: Brett Neumeier <random_at_nospam.com>
Date: 15 Apr 1998 16:58:43 GMT
Message-ID: <6h2p03$dje$5@eve.enteract.com>

Peter Roth <ptroth_ns__at_bechtel.com> wrote:
> Are there ways to ensure that a snapshot is run only after a
> previously executed (scheduled) snapshot has been run
> successfully? Might a solution involve the use of triggers to
> cause the execution of dependent snapshots?

If you're using 7.2 or higher, you can use snapshot refresh groups without a severe performance problem. A snapshot group refreshes in a single logical transaction -- either they all refresh, or none of them do.

Refresh groups are described in chapter 2 of "Oracle7 Server Distributed Systems, Volume II: Replicated Data". Part of the documentation set.

-bn
(the domain is really "enteract") Received on Wed Apr 15 1998 - 11:58:43 CDT