ORA-14098 Even When Indexes and Constraints on the Exchange Table Match the Partitioned Table
(Doc ID 1612345.1)
Last updated on NOVEMBER 07, 2023
Applies to:
Oracle Database Exadata Express Cloud Service - Version N/A and laterOracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A 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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |