UNIQUE constraints mismatch in ALTER TABLE EXCHANGE PARTITION

Solution ID:ORA-14130

Type: Oracle

Cause

One of the tables named in the ALTER TABLE EXCHANGE PARTITION command has a UNIQUE constraint for which no matching (vis-a-vis key columns) constraint is defined on the other table or a matching constraint is defined on the other table, but it differs from that defined on the first table vis-a-vis being enabled and/or validated.

Actions

Ensure that all partition attributes appear within the parenthesized list of descriptions of resulting partitions in ALTER TABLE/INDEX SPLIT PARTITION statement.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


https://community.oracle.com/message/3911292


Browse all solutions to database errors from Oracle, MS SQL, or MySQL