Oracle Solution for Error ora-36679

ORA-36679: (XSDPART17) workspace object

contains a leaf (workspace object

) that is not part of the partition dimension workspace object

.

What triggered the Error:

In the definition of a CONCAT partition template, one of the partitions was dimensioned by a dimension that is "concat-related" to a partition dimension, meaning it shares some leaves with the partition dimension, but it contained some leaves that are not in the partition dimension.

What should we do to fix it:

Either modify the dimensionality of the partition template to include a concat dimension that contains all the desired leaves, or pick a different dimension for the partition.