Re: Serializing the refresh of interdependent materialized views

From: Yavor Ivanov <yavor_ivanov_at_stemo.bg>
Date: 9 Jul 2002 23:54:45 -0700
Message-ID: <9588a8de.0207092254.80861ab@posting.google.com>

Why don't you break the jobs, responsible for refreshning the MView groups and create a custom job, something like that

begin

  dbms_refresh.refresh(a);
  dbms_refresh.refresh(b);
  dbms_refresh.refresh(c);

end;

Note that unles a refresh group is fully refreshed you don't see any changes (no matter it can refresh 100 mviews and in every moment some of them are refreshed, and the rest - not). But with a job like that the changes of refreshing A will be available an useable even before B's and C's refreshes are done. Received on Wed Jul 10 2002 - 01:54:45 CDT