ORA-36260: (XSAGHIERPART00) Aggregating from partition %J to partition %J

michaeljet

ORA-36260: (XSAGHIERPART00) Aggregating frompartition %J to partition %J

over hierarchy workspaceobject creates an increase in sparsity.

Cause: In the partition creation /aggmap creation a situation developed such that

when aggregating over a particular dimension of theaggmap a partition boundary

was crossed such that the sparsity of the targetpartition included dimensions that

were not in the sparsity of the source partition. Sincethe process of aggregation

always densifies rather than sparsifying this is anextremely suboptimal design

and it is not supported by the aggregate system.

Action: Set up your partitioning suchthat for any partition boundary the source

and target partitions of the aggregation will always movetowards denser

partitions. For any child (c) and any parent (p) where(c) and (p) are in different

partitions it must be the case that the parent partitioncontains no dimension in the

composite that the child partition does not contain inits composite.