How to fix the Oracle error ORA-36680: (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.?

In this post, you’ll learn more about the Oracle ErrorORA-36680: (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-36680: (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.

Reason for the Error ORA-36680: (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE.

In the definition of a partition template, one of the partitions was dimensioned by a dimension that was not given in the dimension list of the partition template.

How to fix the Error ORA-36680: (XSDPART18) workspace object is not a dimension of the PARTITION TEMPLATE. ?

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

Remove the offending dimension from the partition’s dimension list, or add it to the partition template’s dimension list.