Oracle Error ORA-37146: (XSCCOMP18) The variable workspace object is already dimensioned by the COMPRESSED COMPOSITE workspace object.

Oracle Error Message

ORA-37146: (XSCCOMP18) The variable workspace object is already dimensioned by the COMPRESSED COMPOSITE workspace object.

Reason for the Error

An attempt was made to define the partition template dimensioned by the COMPRESSED COMPOSITE which had dimensioned the variable.

Solution

Define the second COMPRESSED COMPOSITE.