In this post, you’ll learn more about the Oracle ErrorORA-36685: (XSDPART23) Only CONCAT partition templates can be subpartitioned. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-36685: (XSDPART23) Only CONCAT partition templates can be subpartitioned.
Reason for the Error ORA-36685: (XSDPART23) Only CONCAT partition templates can be subpartitioned.
User attempted to define a RANGE or LIST partition template with one or more partitions dimensioned by another partition template.
How to fix the Error ORA-36685: (XSDPART23) Only CONCAT partition templates can be subpartitioned. ?
You can fix this error in Oracle by following the below steps
Use only regular dimensions and composites to dimension each partition of the RANGE or LIST template.