ERROR | mv omits at least one grouping key from the select list |
CAUSE | The capability in question is not supported when the materialized view omits any grouping expressions from the select list. |
ACTION | Include all GROUP BY expressions in the select list. |