In this post, you’ll learn more about the Oracle ErrorQSM-01101: rollup(s) took place on mv, string with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
QSM-01101: rollup(s) took place on mv, string
Reason for the Error QSM-01101: rollup(s) took place on mv, string
If query’s GROUP BY has one of the higher levels of columns found in the materialized view, then the lower level columns in the materialized view will be rolled up to compute the desired results.
How to fix the Error QSM-01101: rollup(s) took place on mv, string ?
You can fix this error in Oracle by following the below steps
None