Oracle Error ORA-37105: (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions.

Oracle Error Message

ORA-37105: (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions.

Reason for the Error

User attempted to create an external partition on a partitioned variable, but the variable was dimensioned by a RANGE or LIST partition template.

Solution

Declare the partition INTERNAL instead of EXTERNAL, or use a CONCAT partition template in place of the RANGE or LIST partition template.