Re: Snapshot Group

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:

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

Docs:

http://download.oracle.com/docs/cd/B19306_01/server.102/b14227/rarrefreshpac.htm#REPMA018 http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_mview.htm#CEGHCECB

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l