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

Oracle Error Message

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

Reason for the Error

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

Solution

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