Oracle Error ORA-36666: (XSDPART04) workspace object is not a concat dimension.

Oracle Error Message

ORA-36666: (XSDPART04) workspace object is not a concat dimension.

Reason for the Error

User tried to define a partition template with PARTITION BY CONCAT(… dim …) where dim is not a concat dimension.

Solution

Only concat dimensions can serve as partition dimensions with CONCAT partitioning. Choose a different partition dimension.