Refresh of Materialized view on specific times per day
604936Aug 24 2011 — edited Aug 26 2011Hi,
I have a requirement of creating a materialized view which will be refreshed twice daily. It will be refreshed (complete) at 1 a.m. and 1 p.m. daily. Can anyone help me with the syntax.
My requirement is something like
CREATE MATERIALIZED VIEW CRT_DETAILS
NOLOGGING
PARALLEL
REFRESH COMPLETE
ON DEMAND
START WITH SYSDATE NEXT SYSDATE + ?????
as
SELECT columns from joins of tables;
My MV will get created at sysdate. I need to put the NEXT value in such a fashion that it evaluates to 1 a.m. and 1 p.m. daily.