Re: Refresh Materialized view

Posted by Arsalan on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/Refresh-Materialized-view-tp1792p1794.html

Brother

1- I mean this script is good to referesh all Materialzied view or not ?

or  i should create refresh group which one is more useful ?


DECLARE
v_number_of_failures NUMBER(12) := 0;
BEGIN
DBMS_MVIEW.REFRESH_ALL_MVIEWS(v_number_of_failures,'F','', TRUE, FALSE);
END;

Note : I have more then 50 Materialized view .