This discussion is archived
5 Replies Latest reply: Feb 28, 2013 3:25 AM by mynameisajc RSS

Refreshing MV - Automatically Refresh weekly

mynameisajc Pro
Currently Being Moderated
Hi Experts,

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
AS
SELECT
A.column1,b.column2 from
table a ,table b
where
a.column3=b.column4

Thanks
Aswin

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points