ORA-37530: (XSCCLOAD01) When aggregating between compressed partitions the base dimensions of workspace object did not match the base dimensions of workspace object.
Cause: When aggregating a partitioned variable the dimensionality of any compressed partitions should be identical.
Action: 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.
Error Type: ORA