Oracle DB 12.1.0.2
AIX
Hello Team,
we were getting error below :
ORA-12057: materialized view or zonemap "OFSTRIM"."MV_BI_GL_BALANCES_V" is invalid and must use complete refresh
I have executed:
EXEC dbms_mview.explain_mview('OFSTRIM.MV_BI_GL_BALANCES');
we are getting output attached.
mv_capabilities.xlsx (5.77 KB)
Uploaded 6:32 pm5.77 KB
Kindly advise why we cannot do fast refresh and what needs to be modified as per our query?
MV (5).txt (26.79 KB)
Thanks,
Roshan