Oracle Solution for Error ora-36685
ORA-36685: (XSDPART23) Only CONCAT partition templates can be subpartitioned.
What triggered the Error:
User attempted to define a RANGE or LIST partition template with one or more partitions dimensioned by another partition template.What should we do to fix it:
Use only regular dimensions and composites to dimension each partition of the RANGE or LIST template.
If this was not sufficient go over to:
Oracle Official Support Knowledge Center
Or maybe those geeks at: StackOverflow Board
Or maybe those geeks at: StackOverflow Board
