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

NNO-00604: disabling all request processing

1 Answers  


ORA-25271: queue table not found for the given queue

1 Answers  


RMAN-08008: channel string: starting full datafile backupset

1 Answers  


PCC-00089: Invalid Oracle TYPE specification

1 Answers  


ORA-03242: Tablespace migration retried 500 times

1 Answers  






NNL-00905: NOT AUTHORITY responses sent: number

1 Answers  


PCC-00121: Arrays of VARCHAR pointers are not supported

1 Answers  


RMAN-06166: datafile string cannot be recovered

1 Answers  


ORA-23417: unknown materialized view type: string

1 Answers  


ORA-02083: database name has illegal character 'string'

1 Answers  


PLS-01415: Use of aggregate value here

1 Answers  


ORA-24172: rule set string.string has errors

1 Answers  


Categories