ORA-14098 Even When Indexes and Constraints on the Exchange Table Match the Partitioned Table
Last updated on DECEMBER 21, 2017
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Information in this document applies to any platform.
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.
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