view materialized
by williams paillan
santiago de chile
williams.paillan@udp.cl

////////////////////////////


1.- This is a view's example materialized, that an hour refreshes  itself automatically each

*********
DROP MATERIALIZED VIEW MM2;
CREATE MATERIALIZED VIEW MM2
REFRESH COMPLETE with rowid
START WITH sysdate
NEXT sysdate + 1/24
AS Select bank_ont, st_date  
    from dbr_bank_official a, 
         dbr_bank_none b
   where a.bin = b.bin;
**********

2.- Another possibility is to refresh the view, road procedures, or each you see that you get busy 
***********

DROP MATERIALIZED VIEW MM2;
CREATE materialized VIEW MM2
AS SELECT *
FROM tabla_master;
****
procedure pppp
begin
   dbms_mview.refresh('owner.MM2',null,null,true,false,1,0,0,true);
   or
   dbms_mview.refresh('owner.MM2');
 --- Another Declaración or you sentence pl-sql
end pppp;
/
*************