Refresh Materialized view

Posted by Arsalan on Dec 21, 2016; 6:09am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/Refresh-Materialized-view-tp1792.html


Sir

I have more then 50 materialized in my Data warehouse which are dblink with production database.

Example

create materialized view MV_VIEWE_NAME  refresh on demand with rowid as select * from

SIGTASAD.TABLE_NAME@dwhsig_link;


so does it possible to refresh all M view in one command. i have found one example kindly verify it.

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