Oracle Error ORA-36678: (XSDPART16) workspace object is missing from one or more partition dimension lists.

Oracle Error Message

ORA-36678: (XSDPART16) workspace object is missing from one or more partition dimension lists.

Reason for the Error

In the definition of a partition template, one of the partitions had a dimension list that did not contain all the dimensions of the partition template.

Solution

Add the offending dimension to the partition’s dimension list, or delete it from the partition template’s dimension list. If using CONCAT partitioning and the missing dimension is a partition dimension, add to the partition dimension list any leaf of the partition dimension or any concat of leaves of the partition dimension.