Re: Serializing the refresh of interdependent materialized views

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Wed, 10 Jul 2002 17:08:34 +1000
Message-ID: <fZQW8.31805$Hj3.96152@newsfeeds.bigpond.com>

Hi Rick,

Why precisely do you want to do this ?

If the MVs are truly not interrelated, then it shouldn't really matter when the MVs are actually refreshed.

If the MVs are interrelated, then I would recommend having them refreshed together in the same refresh group to guarantee the consistency between the MVs. Oracle manages this for you automatically.

My thoughts

Richard
"Rick Denoire" <100.17706_at_germanynet.de> wrote in message news:b3qmiuouhmdsc7qdndp15j0fn2kegd305b_at_4ax.com...
> Hello
>
> What is the correct way to automate the refreshing of materialized
> views, when several groups of views should be refreshed one group
> after the other?
>
> Let's say I have three groups of materialized views A, B and C. C
> should be refreshed after B, and B after A. How do I setup this time
> concatenation? Fixed times are bad, because the duration of the
> execution may vary. The next group should start the refresh
> inmediately after the prior group is done.
>
> Any hint will be appreciated.
>
> Rick Denoire
Received on Wed Jul 10 2002 - 02:08:34 CDT