Database Error Messages

Release
toggle
  • 23ai
  • 21c
  • 19c
Updated
Jun 24, 2024

OCI-36392

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

Cause

The user did not specify the name of 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.