How to fix the Oracle error ORA-36679: (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.?

In this post, you’ll learn more about the Oracle ErrorORA-36679: (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36679: (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.

Reason for the Error ORA-36679: (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object.

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.

How to fix the Error ORA-36679: (XSDPART17) workspace object contains a leaf (workspace object) that is not part of the partition dimension workspace object. ?

You can fix this error in Oracle by following the below steps

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.