ORA-14098 Even When Indexes and Constraints on the Exchange Table Match the Partitioned Table

(Doc ID 1612345.1)

Last updated on APRIL 04, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.3 and later
Information in this document applies to any platform.

Symptoms

 During partition exchange using the INCLUDING INDEXES clause, you are receiving an ORA-14098 index mismatch for tables in ALTER TABLE EXCHANGE PARTITION even though the the indexes and constraints on the exchange table match those of  the partitioned table.   Using the clause WITHOUT VALIDATION does not prevent the error.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms