1. Categories >> ERRORS >> Database Errors >> Oracle Errors
  2. Suggest New Category

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

Question Posted / guest

Answer Posted / 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       View All Answers


Please Help Members By Posting Answers For Below Questions

ORA-26032: index string.string loading aborted after string keys

1653

IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created

1237

[ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) Unsuccessful: alter table user.CEN_USER_MASTER add constraint FKF4EDEDC3D0BAAE75 foreign key (ROLE_ID) references user.CEN_ROLE_MASTER [ERROR] [main 11:01:20] (JCLLoggerAdapter.java:error:454) ORA-02275: such a referential constraint already exists in the table

2287

IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

2620

ORA-26082: load of overlapping segments on table string.string is not allowed

1376




ORA-26084: direct path context already finished

1483

ORA-26028: index string.string initially in unusable state

3398

when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly

1749

IMG-02003: 2FF03 - incorrect color histogram feature specification

1199

In my project I am using star schema and only diimension tables are loaded and not fact tables any one can help me why it is happening? Plase guide me.

2325

ORA-16627: No standby databases support the overall protection mode.

3554

ORA-16626: failed to enable specified object

1771

IMP-00064: Definition of LOB was truncated by export

5886

NZE-28868: Peer certificate chain check failed.

2263

ORA-16516: The current state is invalid for the attempted operation.

8064