ORACLE: Fast Refresh on Materialized View not working with OUTER JOIN in some conditions
According to My Oracle Support - I found Bug 8856349: Fast refresh of OUTER join materialized view does not work
Bug confirmed in 11.2.0.1, fixed in 11.2.0.2 base release.
The MOS note says that the workaround is to:
Set the parameter "_mv_refresh_pkfk_relationship_opt"=false.
You can change this parameter via the following:
alter system set "_mv_refresh_pkfk_relationship_opt"=false scope=both;However, as this is a hidden parameter, I would either consult Oracle Support (if you have access) as to any potential side effects of setting this parameter, or thoroughly test materialized view refreshes on a test system first before rolling this out to a production system.