Oracle Solution for Error ora-36687

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

.

What triggered the Error:

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

What should we do to fix it:

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