How to fix the Oracle error ORA-36395: (XSMXCLEA05) To CLEAR ALL AGGREGATES from workspace object, you must specify an AGGMAP.?

In this post, you’ll learn more about the Oracle ErrorORA-36395: (XSMXCLEA05) To CLEAR ALL AGGREGATES from workspace object, you must specify an AGGMAP. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36395: (XSMXCLEA05) To CLEAR ALL AGGREGATES from workspace object, you must specify an AGGMAP.

Reason for the Error ORA-36395: (XSMXCLEA05) To CLEAR ALL AGGREGATES from workspace object, you must specify an AGGMAP.

The CLEAR command could not determine how the variable was aggregated because the variable is not dimensioned by a compressed composite.

How to fix the Error ORA-36395: (XSMXCLEA05) To CLEAR ALL AGGREGATES from workspace object, you must specify an AGGMAP. ?

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

Specify an aggmap by adding a USING phrase to the CLEAR command, or attach a ‘$AGGMAP’ property to the variable.