This discussion is archived
2 Replies Latest reply: Jan 14, 2013 11:15 PM by 984891 RSS

Materialized View COMPILATIONS_ERROR

984119 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points