ORA-14294: Number of partitions does not match number of subpartitions

ORA-14294: Number of partitions does not match number of subpartitions

Cause: When exchanging a partitioned table with a composite partition the number of partitions of the table must match the number of subpartitions of the composite partition.

Action: Ensure that the number of partitions in the partitioned table is the same as the number of subpartitions in the the composite partition.

ORA-14293: Number of partitioning columns does not match number of subpartitioning columns

ORA-14293: Number of partitioning columns does not match number of subpartitioning columns

Cause: When exchanging a partitioned table with a composite partition the number of partitioning columns of the table must match the number of subpartitioning columns of the composite partition.

Action: Ensure that the number of partitioning columns in the partitioned table is the same as the number of subpartitioning columns in the the composite partition.

ORA-14292: Partitioning type of table must match subpartitioning type of composite partition

ORA-14292: Partitioning type of table must match subpartitioning type of composite partition

Cause: When exchanging a partitioned table with a composite partition the partitioning type of the table must match the subpartitioning type of the composite partition.

Action: Ensure that the partitioning type of partitioned table is the same as the subpartitioning type of the composite partition.

ORA-14291: cannot EXCHANGE a composite partition with a non-partitioned table

ORA-14291: cannot EXCHANGE a composite partition with a non-partitioned table

Cause: A composite partition can only be exchanged with a partitioned table.

Action: Ensure that the table being exchanged is partitioned or that that the partition being exchanged is non-composite.

ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE (SUB(PARTITION

ORA-14290: PRIMARY KEY constraint mismatch in ALTER TABLE EXCHANGE (SUB(PARTITION

Cause: The corresponding columns in the tables specified in the ALTER TABLE EXCHANGE (SUB(PARTITION statement have different PRIMARY KEY constraints.

Action: Ensure that the two tables do not have PRIMARY KEY constraints defined on any column or disable all PRIMARY KEY constraints on both tables. Then retry the operation.

ORA-14289: cannot make local index partition of Composite Range partitioned table unusable

ORA-14289: cannot make local index partition of Composite Range partitioned table unusable

Cause: User attempted to rebuild a partition of a Composite Range partitioned index which is illegal

Action: none

ORA-14288: index is not partitioned by Composite Range method

ORA-14288: index is not partitioned by Composite Range method

Cause: The index in a partition or subpartition maintenance operation (ALTER INDEX MODIFY (SUBPARTITION|DEFAULT ATTRIBUTES FOR PARTITION( or ALTER INDEX REBUILD SUBPARTITION command must be partitioned by Composite Range method

Action: none