Oracle Solution for Error ora-36392
ORA-36392: (XSMXCLEA02) When using CLEAR with the PRECOMPUTES or NONPRECOMPUTES options, you must specify an AGGMAP.
What triggered the Error:
The user didn't specify an AGGMAP with the CLEAR command.What should we do to fix it:
specify an aggmap by adding a USING phrase to the CLEAR command, or attach a '$AGGMAP' property to the variable.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
