Oracle DB 12.1.0.2
Hello Team,
I have scheduled MV using DBMS_SCHEDULER.
I noticed MV crash with error below in the afternoon.
"ORA-12057: materialized view or zonemap "OFSTRIM"."MV_BI_GL_BALANCES_V" is invalid and must use complete refresh
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 2821
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3051
ORA-06512: at "SYS.DBMS_SNAPSHOT", line 3017
ORA-06512: at line 1
"
Why is complete refresh needed?
Regards,
Roshan