Expand To Show Full Article
Oracle Error ORA-14294: Number of partitions does not match number of subpartitions - Developer Publish

Oracle Error ORA-14294: Number of partitions does not match number of subpartitions

Oracle Error Message

ORA-14294: Number of partitions does not match number of subpartitions

Reason for the Error

When exchanging a partitioned table with a composite partition the number of partitions of the table must match the number of subpartitions of the composite partition.

Solution

Ensure that the number of partitions in the partitioned table is the same as the number of subpartitions in the the composite partition.