ORA-14283: UNIQUE constraints mismatch in ALTER TABLE
EXCHANGE SUBPARTITION



ORA-14283: UNIQUE constraints mismatch in ALTER TABLE EXCHANGE SUBPARTITION..

Answer / guest

Cause: One of the tables named in the ALTER TABLE EXCHANGE
SUBPARTITION 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.

Action: Ensure that for every UNIQUE constraint defined on
one of the tables named in the ALTER TABLE EXCHANGE
SUBPARTITION statement there is a matching (vis-a-vis key
columns and being enabled and/or validated) UNIQUE
constraint defined on the other table. If UNIQUE constrains
are enabled, UNIQUE constraints on the partitioned table
should be enforced using local indexes.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-30930: NOCYCLE keyword is required with CONNECT_BY_ISCYCLE pseudocolumn

1 Answers  


ORA-01615: instance string (thread string) is mounted - cannot disable

1 Answers  


ORA-09960: Unable to establish signal handler for termination signal

1 Answers  


ORA-00327: log string of thread string, physical size string less than needed string

1 Answers  


TNS-12532: TNS:invalid argument

4 Answers  






SQL*Loader-00954: Error shipping index to read buffer across 2-task

1 Answers  


RMAN-06023: no backup or copy of datafile number found to restore

1 Answers  


ORA-31104: Cannot find lock with token "string" on "string" for unlock

1 Answers  


ORA-16001: database already open for read-only access by another instance

1 Answers  


ORA-13912: Critical threshold value is less than warning threshold value.

1 Answers  


ORA-23408: this replication operation is not supported in a mixed configuration

1 Answers  


CLSR-00006: Error encountered when writing file string

1 Answers  


Categories