Oracle Solution for Error ora-36666

Solution for Oracle Error ORA-36666

ORA-36666: (XSDPART04) workspace object

is not a concat dimension.

What triggered the Error:

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

What should we do to fix it:

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