ERROR | MV is not fast refreshable even with view merging |
CAUSE | You have a materialized view with view in the FROM clause, however it does not meet the criteria for fast refresh after view merging. |
ACTION | Restructure the materialized view query to remove the offending view or the complex construct in the view. |