Hi All,
I have a materialized view with refresh rate like this
CREATE MATERIALIZED VIEW MV_TEST
REFRESH FORCE
START WITH SYSDATE
NEXT SYSDATE + 1/24
AS
SELECT * fROM View_TEST
1)Does this mean that the materialized view would be refreshed every hour?
2)If it refreshes every hour what would be starting point time?
3)What if the database is unavailable/down at the time of next refresh time? Does it refresh immediately after the database becomes available?
Pls help me in understanding these. I am quite new to the concept of materialized view.
Thanks in advance.
Anand