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.
