This content has been marked as final. Show 5 replies
Iam in need of creating a MV with automatic refresh every 7 days. Will this query help me to achieve this . Please help me
CREATE MATERIALIZED VIEW Test
REFRESH COMPLETE NEXT TRUNC(SYSDATE) + 7
table a ,table b
you can add below code to refresh mview weekly.
CREATE MATERIALIZED VIEW Test REFRESH FORCE ON DEMAND START WITH SYSDATE NEXT SYSDATE + 7 WITH ROWID AS SELECT A.column1,b.column2 from table a ,table b where a.column3=b.column4