Oracle Error QSM-01096: Materialized view with grouping sets contains duplicates

Oracle Error Message

QSM-01096: Materialized view with grouping sets contains duplicates

Reason for the Error

Materialized view with grouping sets contains duplicates and no rewrite is supported for it. For example, GROUP BY GROUPING SET ((a), (a)) is not supported for rewrite.

Solution

None