Re: Refreshing kust one of the MV's in a refresh group

There are about 150 tabl;es get refreshed. Most of the MV's are fast refreshables but there are some MV's that are created to improve the performance of the queries which take time to refresh as they are complete refresh. We cannot make them fast refreshables as they involve complicated joins and calculations.

The whole thing refreshed as a set.

We even thought of removing the MV and all its dependents / referencesin question from the group and refreshing it seperately . is there a way to get a list of all the tables that are referencing this and maybe we can have 2 groups now.

Frank van Bortel wrote:
> ronnie_yours_at_yahoo.com wrote:
> > Hi,
> >
> > We have oracle 8i and use snapshot replication which gets refreshed
> > every 4 hours.
> >
> > We need to have one MV belonging to the refresh group to be refreshed
> > on demand when a user does a certain operation.
> >
> > Is this possible and will it create any problems later on.
> >
> > We cannot refresh the whole group as it takes around 45 minutes and
> > generates a lot of load on the system.
> >
> > The MV that needs to be refreshed is a fast refreshable one.
> >
> > Thanks
> > Ron
> >
>
> You post 2 questions:
> is it possible: yes, of course. Use the proper call in DBMS_REFRESH,
> or google.
> will it create problems later: yes, of course. Why do you
> think the tables are in one refresh group? I *guess* because they
> have some relationship to each other. If not, why bother?
>
> By the way - why does the replication take so long? Using 28k8
> modems, or what? Ever thought about refreshing hourly, every 20
> minutes?
> --
> Regards,
> Frank van Bortel
Received on Wed Aug 03 2005 - 15:45:53 CDT