ERROR | set operator in mv and compatibility mode is less than 9.0 |
CAUSE | The capability in question is not supported when the materialized view uses a set operator and the compatibility mode is less than 9.0. |
ACTION | Re-phrase the query to avoid the use of set operators or set the compatibility mode to 9.0 or greater. |