Oracle Error ORA-36687: (XSDPART25) You cannot use compressed composite workspace object to dimension multiple partitions of the partition template, because its dimension list includes the PARTITION BY dimension workspace object.

Oracle Error Message

ORA-36687: (XSDPART25) You cannot use compressed composite workspace object to dimension multiple partitions of the partition template, because its dimension list includes the PARTITION BY dimension workspace object.

Reason for the Error

The specified PARTITION BY dimension also occurred in the dimension list of a compressed composite used to dimension multiple partitions.

Solution

Ensure that no PARTITION BY dimension occurs among the bases of the compressed composite used to dimension multiple partitions.