Oracle Solution for Error ora-36670

ORA-36670: (XSDPART08) workspace object

is an INTEGER or NTEXT dimension, or contains an INTEGER or NTEXT dimension. INTEGER and NTEXT dimensions cannot be used as partition dimensions.

What triggered the Error:

User attempted to define a partition template partitioned by an INTEGER or NTEXT dimension or a concat containing an NTEXT leaf.

What should we do to fix it:

Either pick a different partition dimension, or redefine the dimension to use a different datatype.