ORA-37129: (XSCCOMP04) Cannot aggregate over COMPRESSED COMPOSITE workspace object
using AGGMAP workspace object. All static MODEL statements must precede all RELATION statements over the bases of the COMPRESSED COMPOSITE.What triggered the Error:
The AGGMAP was defined with a MODEL statement after a RELATION statement over a base of the COMPRESSED COMPOSITE.What should we do to fix it:
Change the AGGMAP so that the MODEL statements appear before the RELATION statements.