How to fix the Oracle error ORA-37147: (XSCCOMP21) The variable workspace object must be in the current operation group of the COMPRESSED COMPOSITE workspace object.?

In this post, you’ll learn more about the Oracle ErrorORA-37147: (XSCCOMP21) The variable workspace object must be in the current operation group of the COMPRESSED COMPOSITE workspace object. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-37147: (XSCCOMP21) The variable workspace object must be in the current operation group of the COMPRESSED COMPOSITE workspace object.

Reason for the Error ORA-37147: (XSCCOMP21) The variable workspace object must be in the current operation group of the COMPRESSED COMPOSITE workspace object.

The variable dimensioned by the COMPRESSED COMPOSITE was not in the object list of the current operation group. For AGGREGATE, all variables dimensioned by the same COMPRESSED COMPOSITE also must use the same aggmap

How to fix the Error ORA-37147: (XSCCOMP21) The variable workspace object must be in the current operation group of the COMPRESSED COMPOSITE workspace object. ?

You can fix this error in Oracle by following the below steps

Add the variable into the object list of the current operation group.