Re: Snapshot Group
Date: Wed, 7 May 2008 10:49:39 -0700
On Tue, Apr 29, 2008 at 3:13 PM, Sanjay Mishra <smishra_97_at_yahoo.com> 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:
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 -- http://www.freelists.org/webpage/oracle-lReceived on Wed May 07 2008 - 12:49:39 CDT