In this post, you’ll learn more about the Oracle ErrorORA-37105: (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-37105: (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions.
Reason for the Error ORA-37105: (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions.
User attempted to create an external partition on a partitioned variable, but the variable was dimensioned by a RANGE or LIST partition template.
How to fix the Error ORA-37105: (XSVPART05) Only variables dimensioned by a CONCAT PARTITION TEMPLATE can have string partitions. ?
You can fix this error in Oracle by following the below steps
Declare the partition INTERNAL instead of EXTERNAL, or use a CONCAT partition template in place of the RANGE or LIST partition template.