Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Serializing the refresh of interdependent materialized views

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US