Materialized View COMPILATIONS_ERROR
984119Jan 10 2013 — edited Jan 15 2013Hi
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