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@xxxxxxxxxxx>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* >