Re: Refresh multiple MV's in a single transaction
- From: "Finn Jorgensen" <finn.oracledba@xxxxxxxxx>
- To: "Goulet, Richard" <Richard.Goulet@xxxxxxxxxxx>
- Date: Wed, 5 Nov 2008 16:32:15 -0500
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*
>
Other related posts:
