Oracle Solution for Error ora-36672

Solution for Oracle Error ORA-36672

ORA-36672: (XSDPART10) A RANGE or LIST PARTITION TEMPLATE can only have a single partition dimension.

What triggered the Error:

User attempted to define a RANGE or LIST partition template with more than one partition dimension.

What should we do to fix it:

Remove all but one of the dimensions from the PARTITION BY RANGE(...) or PARTITION BY LIST(...) clause of the partition template definition.