Exchange Partition issue.
We have a composite partitioned table(Range-Hash partition):
while exchanging the subpartition with a non partitioned table, it is showing the following error:
ORA-14278: column type or size mismatch in EXCHANGE SUBPARTITION
But both the tables have same columns and size.
Current version of database is 11.2.0.2.0.
what could be the cause, according to metalink note 264302.1, it is a bug which has been resolved in 10gR2.
regards
Rishabh