Oracle Solution for Error ora-37130

ORA-37130: (XSCCOMP05) Cannot aggregate over COMPRESSED COMPOSITE workspace object

using AGGMAP workspace object

because you must specify AGGINDEX OFF when there is a PRECOMPUTE clause on a RELATION over base workspace object

.

What triggered the Error:

A PRECOMPUTE clause was specified in the AGGMAP for a RELATION over a base of a COMPRESSED COMPOSITE, but AGGINDEX was ON

What should we do to fix it:

Remove the PRECOMPUTE clause from the AGGMAP, or add AGGINDEX OFF