OCI-31975
too many GROUP BY expressions in CREATE MATERIALIZED ZONEMAP statement
Cause
The GROUP BY clause of the AS subquery of a CREATE MATERIALIZED ZONEMAP statement contained more than one 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.