Oracle Error ORA-37531: (XSCCLOAD02) When aggregating between compressed partitions the source partitions were aggregated with a different AGGMAP, or the RELATIONS have changed since the source partitions were aggregated.

Oracle Error Message

ORA-37531: (XSCCLOAD02) When aggregating between compressed partitions the source partitions were aggregated with a different AGGMAP, or the RELATIONS have changed since the source partitions were aggregated.

Reason for the Error

When aggregation crosses partition boundaries within a compressed variable the individual partitions must all be aggregated using a similar aggmap over the same unaltered relations.

Solution

Modify the aggmap for the upper partition to more exactly match the aggmap of the source partitions, or if the aggmap is already similar, re-aggregate the source partitions to pick up any changes to the relations.