Oracle Solution for Error ora-37146

Solution for Oracle Error ORA-37146

ORA-37146: (XSCCOMP18) The variable workspace object

is already dimensioned by the COMPRESSED COMPOSITE workspace object

.

What triggered the Error:

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

What should we do to fix it:

Define the second COMPRESSED COMPOSITE.