5 Replies Latest reply: May 12, 2008 12:24 AM by user622720 RSS

    ORA-23420: interval must evaluate to a time in the future

    user622720
      Hi to All,

      While creating matrelized view im facing this error.Can any one help me on this.

      ORA-23420: interval must evaluate to a time in the future
      ORA-06512: at "SYS.DBMS_JOB", line 57
      ORA-06512: at "SYS.DBMS_JOB", line 134
      ORA-06512: at "SYS.DBMS_IREFRESH", line 186
      ORA-06512: at "SYS.DBMS_IREFRESH", line 369
      ORA-06512: at "SYS.DBMS_REFRESH", line 88
      ORA-06512: at "SYS.DBMS_REFRESH", line 62
      ORA-06512: at "SYS.DBMS_ISNAPSHOT", line 76
      ORA-06512: at line 1


      Thanks