Oracle Error QSM-01296: query rewrite not possible because materialized view contains duplicate grouping sets

Oracle Error Message

QSM-01296: query rewrite not possible because materialized view contains duplicate grouping sets

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