Oracle Solution for Error ora-36678

ORA-36678: (XSDPART16) workspace object

is missing from one or more partition dimension lists.

What triggered 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.

What should we do to fix it:

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.