Oracle Solution for Error ora-37530

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

did not match the base dimensions of workspace object

.

What triggered the Error:

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

What should we do to fix it:

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.