We have batch script to refresh the materialized view automatically on 1st of every month.
We got the error below during the MV refresh yesterday (1st of Nov, 2015).
ERROR at line 1:
ORA-12057: materialized view "XXX_DB"."XXX_MV" is INVALID and must
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2809
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3025
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2994
ORA-06512: at "XXX_DB.LOAD_MV_MONTHLY", line 251
ORA-06512: at line 1
Version: Oracle 11g
Recently our Oracle data warehouse has been migrated into Super Cluster pltform.
+ORA-12057:materialized view "string"."string" is INVALID and must complete refresh+
+Cause:The status of the materialized view was INVALID and an attempt was made to fast refresh the materialized view.+
+Action:Perform a complete refresh of the materialized view. Check the value of the STATUS column in dba_mviews, all_mviews, or user_mviews to verify that the materialized view is VALID after the complete refresh.+