Re: Mviews Refresh Timings

From: Ind-dba <oraclearora_at_googlemail.com>
Date: Wed, 11 Mar 2009 04:28:49 -0700 (PDT)
Message-ID: <f0f34905-54af-4a4d-b4f8-74f4a2a4fd57_at_b38g2000prf.googlegroups.com>

I feel it is better to rewrite the job to do mview refresh and insert th log in table .. something like :

begin

insert into mview_log_table('X_MVIEW',sysdate,'START');
dbms_mview.refresh('X_MVIEW','C');
insert into mview_log_table('X_MVIEW',sysdate,'END');
insert into mview_log_table('Y_MVIEW',sysdate,'START');
dbms_mview.refresh('X_MVIEW','C');
insert into mview_log_table('Y_MVIEW',sysdate,'END');

end;
/ Received on Wed Mar 11 2009 - 06:28:49 CDT