Oracle Error Codes

table cannot be used in EXCHANGE

An attempt was made to issue an ALTER TABLE EXCHANGE PARTITION | SUBPARTITION command, but the non-partitioned table cannot be used in the EXCHANGE because one or more of the following apply: – it is a typed table – it contains ADT columns – it contains nested-table columns – it contains REF columns – it contains array columns – it is an index-organized table – it contains LOB columns – it is a nested table – it is created with row dependency and the partitioned table is not – it is created without row dependency and the partitioned table is

How to Solve :

Make sure the non-partitioned table does not violate any of the above restrictions for the ALTER TABLE EXCHANGE PARTITION | SUBPARTITION command.