Re: Snapshot Group

From: Jared Still <>
Date: Wed, 7 May 2008 10:49:39 -0700
Message-ID: <>

On Tue, Apr 29, 2008 at 3:13 PM, Sanjay Mishra <> wrote:

> I want to create 10 MV and all of them will be refreshed complete daily
> at 11pm. These are not big MVs but I want that they should be either
> refreshed all and avoid the scenario when 5 are refreshed but 5 are not so
> as to avoid data inconsistency.
> It look like that I can do by creating Refresh Group. Can somebod share
> related doc or link.

In a nutshell:

create MV's
remove MV's from their own snapshot group via dbms_refresh.subtract create a new refresh group with dbms_refresh.make


Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

Received on Wed May 07 2008 - 12:49:39 CDT

Original text of this message