ORA-31976
invalid expression in the GROUP BY clause of a CREATE MATERIALIZED ZONEMAP statement
Cause
The GROUP BY clause of the AS subquery of a CREATE MATERIALIZED ZONEMAP statement contained an expression that was not the SYS_OP_ZONE_ID function expression.
Action
Update the GROUP BY clause of the AS subquery of the CREATE MATERIALIZED ZONEMAP statement to have one expression, which must be the same SYS_OP_ZONE_ID function expression specified for the first column of the SELECT list of the subquery.