Database Error Messages

OCI-37140

(XSCCOMP15) %a workspace object workspace object
Cannot AGGREGATE partitioned variable %1p using AGGMAP %2p because you cannot use the base of a COMPRESSED COMPOSITE as a partition dimension.

Cause

The user tried to run aggregate on a partitioned variable with a partition dimension that is a base of a COMPRESSED COMPOSITE.


Action

Repartition the data, drop the partition dimension from the aggmap, or don't use COMPRESSED COMPOSITES.