Oracle Error ORA-37128: (XSCCOMP20) The partition template workspace object has already used the COMPRESSED COMPOSITE workspace object.

Oracle Error Message

ORA-37128: (XSCCOMP20) The partition template workspace object has already used the COMPRESSED COMPOSITE workspace object.

Reason for the Error

The COMPRESSED COMPOSITE specified for either a variable or partition template is already in use in another partition template.

Solution

Define a different COMPRESSED COMPOSITE.