How to fix the Oracle error ORA-36665: (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.?

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

Oracle Error Description

ORA-36665: (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.

Reason for the Error ORA-36665: (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE.

While defining a partition template, user attempted to specify a partition dimension that is not a dimension of the partition template itself.

How to fix the Error ORA-36665: (XSDPART03) workspace object is not in the dimension list of the PARTITION TEMPLATE. ?

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

Choose a partition dimension from among the dimensions of the partition template.