Thursday, 15 March 2012

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