How to fix the 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.?

In this post, you’ll learn more about the Oracle ErrorORA-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. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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 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.

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.

How to fix the 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. ?

You can fix this error in Oracle by following the below steps

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.