How to fix the Oracle error QSM-02184: Expression to enable PCT cannot be rolled up?

In this post, you’ll learn more about the Oracle ErrorQSM-02184: Expression to enable PCT cannot be rolled up with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

QSM-02184: Expression to enable PCT cannot be rolled up

Reason for the Error QSM-02184: Expression to enable PCT cannot be rolled up

The capability in question is not supported when the expression is rolled up

How to fix the Error QSM-02184: Expression to enable PCT cannot be rolled up ?

You can fix this error in Oracle by following the below steps

Change the query so that the expression is not rolled up