ORA-37129: (XSCCOMP04) Cannot aggregate over COMPRESSED COMPOSITE

michaeljet

ORA-37129: (XSCCOMP04) Cannot aggregate overCOMPRESSED COMPOSITE

workspace object usingAGGMAP workspace object. Allstatic MODEL

statements must precede all RELATIONstatements over the bases of the

COMPRESSED COMPOSITE.

Cause: The AGGMAP was defined with aMODEL statement after a RELATION

statement over a base of the COMPRESSED COMPOSITE.

Action: Change the AGGMAP so that the MODELstatements appear before the

RELATION statements.