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 is a temporary 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.
OARA-14132错误是引发的基本错误,由于在数据库中使用了不兼容的EXCHANGE运算符(例如空分区表),而无法解决此问题。
ORA-14132:表不能用于EXCHANGE
当以下语句出现错误:
ALTER TABLE