5 Replies Latest reply: Feb 28, 2013 5:25 AM by bi007 RSS

    Refreshing MV - Automatically Refresh weekly

    bi007
      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