How to fix the Oracle error ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must specify an AGGMAP.?

In this post, you’ll learn more about the Oracle ErrorORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, 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-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must specify an AGGMAP.

Reason for the Error ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must specify an AGGMAP.

The user didn’t specify an AGGMAP with the CLEAR command.

How to fix the Error ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, 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.