Oracle DBA, How To, Error, Cause and Action

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.

No comments:

Post a Comment

Thanks for your comment.