Results 1 to 3 of 3
  1. #1
    Join Date
    May 2004
    Posts
    184

    Unanswered: Materialized view NEXT parameter

    I'm trying to create a materialized view that will refresh itself every X hours. I tried using "NEXT 4/24 " to have it refresh every 4 hours, but this generates an error about expecting a date instead of a number. Is it possible to specify that a materialized view refreshes every X hours instead of a specific day and time?

    Thank you.

  2. #2
    Join Date
    May 2006
    Posts
    132
    Have you tried?

    Code:
    NEXT sysdate + 4/24

  3. #3
    Join Date
    May 2004
    Posts
    184
    ebrian,

    Thanks. That's just way too obvious-. I'll give that a try.

    Thank you.

Posting Permissions

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