ORA-14294: Number of partitions does not match number of subpartitions
What triggered 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.What should we do to fix it:
Ensure that the number of partitions in the partitioned table is the same as the number of subpartitions in the the composite partition.