How to fix the Oracle error ORA-14129: INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints?

In this post, you’ll learn more about the Oracle ErrorORA-14129: INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

ORA-14129: INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints

Reason for the Error ORA-14129: INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints

Matching UNIQUE constraints in both table are enabled and validated but INCLUDING INDEXES is not specified in ALTER TABLE EXCHANGE PARTITION|SUBPARTITION command.

How to fix the Error ORA-14129: INCLUDING INDEXES must be specified as tables have enabled UNIQUE constraints ?

You can fix this error in Oracle by following the below steps

Disable currently enabled matching UNIQUE constraints on both tables or ensure that INCLUDING INDEXES option is used.