ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

文档解释

ORA-14098: index mismatch for tables in ALTER TABLE EXCHANGE PARTITION

Cause: The two tables specified in the EXCHANGE have indexes which are not equivalent

Action: Ensure that the indexes for the two tables have indexes which follow this rule For every non partitioned index for the non partitioned table, there has to be an identical LOCAL index on the partitioned table and vice versa. By identical, the column position, type and size have to be the same.

ORA-14098：在ALTER TABLE EXCHANGE PARTITION操作中索引不匹配

官方解释

常见案例

1. 使用ALTER TABLE EXCHANGE PARTITION时使用错误的索引名称，导致“ORA-14098”

2. 对索引的分区数量不同，导致ORA-14098

正常处理方法及步骤

1. 使用正确的索引名称，以解决对索引使用错误名称导致“ORA-14098”的错误

2. 使用相同数量的索引分区，以解决索引分区数量不同而导致“ORA-14098”的错误