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

Oracle Error Message

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

Reason for the Error

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

Solution

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