ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must specify an AGGMAP.
Cause: The user didn''t specify an AGGMAP with the CLEAR command.
Action: specify an aggmap by adding a USING phrase to the CLEAR command, or attach a ''$AGGMAP'' property to the variable.
Error Type: ORA