Re: Refresh multiple MV's in a single transaction

That's what I thought it was for too, but it's not. See my original post :)

>This works on 10.2.0.4, I don't see why it would not work on 10.2.0.2:
>Dbms_Mview.Refresh_All_Mviews(Failures,'?','',TRUE,FALSE);

I will look into this although the "atomic_refresh" parameter is also present in dbms_mview.refresh(list) and defaults to "true" (according to the documentation) but it doesn't work like that.

Thanks!

Finn

On Wed, Nov 5, 2008 at 4:00 PM, Goulet, Richard <Richard.Goulet_at_parexel.com>wrote:

> Look into refresh groups. You can have multiple MV's in a single refresh
> group. *Oracle(R) Database Advanced Replication, 3 Materialized View
> Concepts and Architecture*
>

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