ORA-14132
table cannot be used in EXCHANGE
Cause
An attempt was made to issue an ALTER TABLE EXCHANGE PARTITION | SUBPARTITION statement, 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
Ensure that the non-partitioned table does not violate any of the above restrictions for the ALTER TABLE EXCHANGE PARTITION | SUBPARTITION statement.
ORA-14132
table cannot be used in EXCHANGE
Cause
An attempt was made to issue an ALTER TABLE EXCHANGE PARTITION | SUBPARTITION statement, 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
Ensure that the non-partitioned table does not violate any of the above restrictions for the ALTER TABLE EXCHANGE PARTITION | SUBPARTITION statement.
ORA-14132
table cannot be used in EXCHANGE
Cause
An attempt was made to issue an ALTER TABLE EXCHANGE PARTITION | SUBPARTITION statement, 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
Ensure that the non-partitioned table does not violate any of the above restrictions for the ALTER TABLE EXCHANGE PARTITION | SUBPARTITION statement.