Oracle Error ORA-36664: (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.

Oracle Error Message

ORA-36664: (XSDPART02) You must specify a partitioning method and one or more partition dimensions when defining a PARTITION TEMPLATE.

Reason for the Error

User tried to define a PARTITION TEMPLATE without a PARTITION BY clause.

Solution

Add a PARTITION BY clause.