How to fix the 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.?

In this post, you’ll learn more about the Oracle ErrorORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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 ORA-36391: (XSMXCLEA01) When CLEAR is used with the STATUS keyword or an AGGMAP, workspace object must be dimensioned identically to workspace object.

The user specified objects whose dimensionality didn’t match

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

You can fix this error in Oracle by following the below steps

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