Oracle Database 12c New Features

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

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


Cause:


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



Action:


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