Oracle Error ORA-37530: (XSCCLOAD01) When aggregating between compressed partitions the base dimensions of workspace object did not match the base dimensions of workspace object.

Oracle Error Message

ORA-37530: (XSCCLOAD01) When aggregating between compressed partitions the base dimensions of workspace object did not match the base dimensions of workspace object.

Reason for the Error

When aggregating a partitioned variable the dimensionality of any compressed partitions should be identical.

Solution

Delete the upper partition and redefine it with a composite that matches the lower partition. If it is dependent on multiple partitions with varying sparsity you must first unify the the sparsity of the source partitions.