Oracle Error ORA-37135: (XSCCOMP19) The COMPRESSED COMPOSITE workspace object in the current defined partition template should be unique or global.

Oracle Error Message

ORA-37135: (XSCCOMP19) The COMPRESSED COMPOSITE workspace object in the current defined partition template should be unique or global.

Reason for the Error

The COMPRESSED COMPOSITE was neither unique nor global. Unique means each subpartition should have different COMPRESSED COMPOSITEs; Global means all subpartitions should use the same COMPRESSED COMPOSITE if they use any COMPRESSED COMPOSITE.

Solution

Redefine the partition template.