ERROR | subquery and UNION mvs must be primary key mvs |
CAUSE | The capability in question is not supported when the materialized view is not a primary key materialized view and uses subqueries or the union operator in this context. |
ACTION | Re-create the materialized view as a primary key materialized view. |