Oracle Error ORA-36201: (XSAGGR35) Cannot aggregate workspace object(partition workspace object) because the subpartition is itself partitioned.

Oracle Error Message

ORA-36201: (XSAGGR35) Cannot aggregate workspace object(partition workspace object) because the subpartition is itself partitioned.

Reason for the Error

Attempted to aggregate an intermediate partition of a variable with nested partitioning.

Solution

rerun the aggregate command seperately for each ultimate partition or just for the variable as a whole