Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003

    Unanswered: Set refresh date in materialized view

    I want to make the refresh of a materialized view every quarter hour.
    If I make SYSDATE+15/1440 the value of the next date change a few seconds (the time that the job spend to refresh data).
    So I want something that can make the refresh without delays (00m, 15m, 30m and at 45m).

  2. #2
    Join Date
    Feb 2004
    You my schedule a job using dbms_job to refresh if you don't want to use the default refresh mechanism

    Hope this helps,
    Jitendra Agrawal

    SNMP++ Document

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts