Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


ORA-14131: enabled UNIQUE constraint exists on one of the tables



ORA-14131: enabled UNIQUE constraint exists on one of the tables..

Answer / guest

Cause: One of the tables referenced in the ALTER TABLE
EXCHANGE PARTITION|SUBPARTITION statement has enabled UNIQUE
constraint(s) defined on it, which prevents EXCHANGE from
proceeding.

Action: Disable constraints defined on tables referenced in
the ALTER TABLE EXCHANGE PARTITION|SUBPARTITION statement
and retry the statement.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-22878: duplicate LOB partition or subpartition specified

1 Answers  


ORA-36815: (XSTBLFUNC08) The OLAP_TABLE has attempted to use an AW single row function with the aw_attach parameter set to DURATION QUERY.

1 Answers  


PCB-00109: Unable to open generated source file "string"

1 Answers  


ORA-23470: invalid status

1 Answers  


ORA-14304: List partitioning method expects a single partitioning column

1 Answers  






TNS-01043: Password changed for string

1 Answers  


ORA-38306: this object is not recoverable standalone

1 Answers  


ORA-02802: No idle servers available in parallel mode

1 Answers  


DRG-12015: The source document for this operation has moved - continue?

1 Answers  


NZE-29052: Write buffer is not empty.

1 Answers  


ORA-09821: Numeric label is not valid

1 Answers  


TNS-01053: Connecting to string

1 Answers  






Categories