From: oracledba <>
Date: Fri, 13 Sep 2013 09:54:26 -0400
Message-ID: <>

Actually i am trying to list out materialized views which are not refreshed based on its interval and next_date and last_date.Since MVs are refreshed at different intervals i need to report when MV refresh is failed. I don't want to use "broken" column for it.Interval in dba_jobs is a varchar column.

On Fri, Sep 13, 2013 at 6:28 AM, Sayan Malakshinov <>wrote:

> You can do the same without regexp: replace(str,'SYSDATE', 0)

Received on Fri Sep 13 2013 - 15:54:26 CEST

Original text of this message