Oracle Error ORA-36685: (XSDPART23) Only CONCAT partition templates can be subpartitioned.

Oracle Error Message

ORA-36685: (XSDPART23) Only CONCAT partition templates can be subpartitioned.

Reason for the Error

User attempted to define a RANGE or LIST partition template with one or more partitions dimensioned by another partition template.

Solution

Use only regular dimensions and composites to dimension each partition of the RANGE or LIST template.