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

DRG-13010: alt_value is already used by another sub lexer

1 Answers  


ORA-10921: Cannot drop tablespace belonging to default temporary tablespace group

1 Answers  


ORA-06706: TLI Driver: service not found

1 Answers  


ORA-06019: NETASY: invalid login (connect) string

1 Answers  


ORA-07472: snclrd: open error when opening sgadef.dbf file.

1 Answers  


PLS-00129: Pragma INTERFACE only supports C as its first argument

1 Answers  


ORA-12538: TNS:no such protocol adapter

1 Answers  


ORA-38309: object not purgable

1 Answers  


ORA-27077: too many files open

1 Answers  


PROC-00011: Cannot perform cluster registry operation because key is NULL.

1 Answers  


ORA-38432: EVALUATE operator only allowed on an expression column

1 Answers  


RMAN-08009: channel string: starting archive log backupset

1 Answers  


Categories