ORA-31974
missing GROUP BY clause in CREATE MATERIALIZED ZONEMAP statement
Cause
A CREATE MATERIALIZED ZONEMAP statement did not have a GROUP BY clause in the AS subquery.
Action
Add a GROUP BY clause to the AS subquery of the CREATE MATERIALIZED ZONEMAP statement. The GROUP BY clause must use the same SYS_OP_ZONE_ID function expression specified for the first column of the SELECT list of the subquery.