Re: Snapshot Group
- From: "Jared Still" <jkstill@xxxxxxxxx>
- To: smishra_97@xxxxxxxxx
- Date: Wed, 7 May 2008 10:49:39 -0700
On Tue, Apr 29, 2008 at 3:13 PM, Sanjay Mishra <smishra_97@xxxxxxxxx> 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
Other related posts:
