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; / *************