Oracle Solution for Error ora-36391

Solution for Oracle Error ORA-36391

ORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object

must be dimensioned identically to workspace object

.

What triggered the Error:

The user specified objects whose dimensionality didn't match

What should we do to fix it:

Break up the CLEAR command into multiple commands where the dimensionality of the objects matches