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

Oracle Error Message

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

Reason for the Error

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

Solution

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