Re: replicating snapshots (multitiered materialized views)..

That's what I think it is. Luckily the mviews I am replicating are not that big, I can just do a complete refresh hourly.

I guess what I was trying to accomplish is not really a function of logs and fast refresh (e.g. stick all (site b) mviews in a group, refresh it hourly, but the group would figure out which snapshots to refresh based on when the 'master complex mview' was refreshed.

I am posting another question though, hope you can help out :)

Thanks.

On 11 Feb 2005 10:44:10 -0800, "Anurag Varma" <avoracle_at_gmail.com> wrote:

>
>One more thing I realized.
>
>If your complex mview (a_mview) is being refreshed complete.
>Then you cannot fast refresh any nested mviews based on that.
>Its quite simple: complete refresh causes the a_mview to be
>truncated and repopulated. The truncate causes the mview log
>on a_mview to be purged also.
>
>This then causes fast refreshes on a_mview to fail also with
>the error you are getting.
>
>I think this is what you are really encountering.
>
>Anurag
>

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Feb 11 2005 - 13:04:47 CST