Re: materialized view execution

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

Hi Arsala,

You can use "materialized view Refresh Groups" for that.

3 Ara 2016 07:52 tarihinde "Arsala saleem [via Erman Arslan's Oracle Forum]" <[hidden email]> yazdı:

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

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/materialized-view-execution-tp1648.html

To start a new topic under Database, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML