ORA-14292: Partitioning type of table must match subpartitioning type of composite partition
What triggered the Error:
When exchanging a partitioned table with a composite partition the partitioning type of the table must match the subpartitioning type of the composite partition.What should we do to fix it:
Ensure that the partitioning type of partitioned table is the same as the subpartitioning type of the composite partition.