materialized view execution

Posted by Arsalan on Dec 03, 2016; 4:39am
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/materialized-view-execution-tp1648.html


Salam bro.

I have 100 materialized view so how to manually refresh it .

scott/tiger

set serveroutput on

declare
cursor c_emp is select * from user_objects s where s.OBJECT_TYPE='MATERIALIZED VIEW';
r_emp c_emp%rowtype;
B VARCHAR2(13);
begin
open c_emp;
for i in 1..100 loop
fetch c_emp into r_emp;
exit when c_emp%notfound;
dbms_output.put_line('execute dbms_mview.refresh('||'list=>'||r_emp.object_name||','||'method=>'||'F'||')');
end loop;
close c_emp;
end;
/
---- this is the out put

execute dbms_mview.refresh(list=>BONUS,method=>F)

execute dbms_mview.refresh(list=>DEPT,method=>F)

-------but i want output line below to refresh the materialized view

execute dbms_mview.refresh( list => 'BONUS', method => 'F' );


please guide me other easy way how to execute or refresh 100 materialized view
in one command because i have 100 materialized view