› Fóruns › Banco de dados Oracle › Materialized View › Materialized View
6 de agosto de 2010 às 6:07 am
#95411
juliano_sfParticipante
Opa,
No próprio comando CREATE MATERIALIZED VIEW vc pode especificar quando será o proximo refresh:
CREATE MATERIALIZED VIEW mv_complete
TABLESPACE uwdata
REFRESH COMPLETE
START WITH SYSDATE
NEXT SYSDATE + 1 AS
SELECT s.srvr_id, i.installstatus, COUNT(*)
FROM servers s, serv_inst i
WHERE s.srvr_id = i.srvr_id
GROUP BY s.srvr_id, i.installstatus;
Abraços,
Juliano