How to fix the Oracle error ORA-36767: (XSAGGCNTMOVE05) workspace object cannot be used as an AGGCOUNT while there are permissions applied to it.?

In this post, you’ll learn more about the Oracle ErrorORA-36767: (XSAGGCNTMOVE05) workspace object cannot be used as an AGGCOUNT while there are permissions applied to it. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36767: (XSAGGCNTMOVE05) workspace object cannot be used as an AGGCOUNT while there are permissions applied to it.

Reason for the Error ORA-36767: (XSAGGCNTMOVE05) workspace object cannot be used as an AGGCOUNT while there are permissions applied to it.

The specified AGGCOUNT variable had its own permissions distinct from those on the aggregation variable.

How to fix the Error ORA-36767: (XSAGGCNTMOVE05) workspace object cannot be used as an AGGCOUNT while there are permissions applied to it. ?

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

Select a different AGGCOUNT variable, or remove the permissions. In some cases this may require an UPDATE before the command can succeed.