Tag Archives: ORA-14132

ORA-14132: table cannot be used in EXCHANGE

oracle

ORA-14132: table cannot be used in EXCHANGE
Cause: 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
Action: Make sure the non-partitioned table does not violate any of the above restrictions for the ALTER TABLE EXCHANGE PARTITION | SUBPARTITION command.

Back to previous menu