2 Replies Latest reply: Jan 15, 2013 1:15 AM by 984891 RSS

    Materialized View COMPILATIONS_ERROR

    984119
      Hi

      I have 3 MVs set up on my 10.2 database.
      All 3 materialized views are scheduled to refresh after certain period of time (25 min).
      After they refresh, it shows a red cross on the materialized views. I am wondering what is causing the red cross.
      Also it shows staleness = COMPILATION_ERROR

      All 3 materialized views are scheduled to refresh after certain period of time (25 min).
      After they refresh, it shows a red cross on the materialized views. I am wondering what is causing the red cross.
      Also it shows staleness = COMPILATION_ERROR

      CREATED               21-DEC-12
      LAST_DDL_TIME          21-DEC-12
      OWNER               qqq
      MVIEW_NAME               abc
      CONTAINER_NAME          abc
      QUERY_LEN               13734
      UPDATABLE               N
      UPDATE_LOG     
      MASTER_ROLLBACK_SEG     
      MASTER_LINK     
      REWRITE_ENABLED          N
      REWRITE_CAPABILITY          GENERAL
      REFRESH_MODE          DEMAND
      REFRESH_METHOD          COMPLETE
      BUILD_MODE               IMMEDIATE
      FAST_REFRESHABLE          NO
      LAST_REFRESH_TYPE          COMPLETE
      LAST_REFRESH_DATE          10-JAN-13
      STALENESS               COMPILATION_ERROR
      AFTER_FAST_REFRESH          COMPILATION_ERROR
      UNKNOWN_PREBUILT          N
      UNKNOWN_PLSQL_FUNC     N
      UNKNOWN_EXTERNAL_TABLE     N
      UNKNOWN_CONSIDER_FRESH     N
      UNKNOWN_IMPORT     N
      UNKNOWN_TRUSTED_FD     N
      COMPILE_STATE          COMPILATION_ERROR
      USE_NO_INDEX          N
      STALE_SINCE

      Not sure why is this happening