Oracle Solution for Error ora-36201

ORA-36201: (XSAGGR35) Cannot aggregate workspace object

(partition workspace object

) because the subpartition is itself partitioned.

What triggered the Error:

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

What should we do to fix it:

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