Oracle Error ORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.

Oracle Error Message

ORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.

Reason for the Error

The user specified objects whose dimensionality didn’t match

Solution

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