4 Replies Latest reply on Jun 27, 2014 11:12 AM by Mark Addleman

    Materialized view timeout possible?

    Mark Ackert Newbie

      Hi,

       

      I'm running into an issue with a materialized view being stuck in a "loading" state. Why the view is stuck is still being researched, but one question I had is if it's possible to specify a timeout on the materialized view's attempt to load. This way, queries being run against the "loading" view won't block indefinitely. Further along that line of questioning - if a materialized view could have a timeout, would it be possible for the view to attempt another load if it failed the previous time?

       

      Thanks!

      -Mark