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.

Share:

Leave A Reply

Your email address will not be published. Required fields are marked *

You May Also Like

Oracle Error Message ORA-24328: illegal attribute value Reason for the Error The attribute value passed in is illegal. Solution Consult...
Oracle Error Message ORA-01346: LogMiner processed redo beyond specified reset log scn Reason for the Error LogMiner has detected a...
Oracle Error Message ORA-13241: specified dimensionality does not match that of the data Reason for the Error An error occurred...