ORA-02270: no matching unique or primary key for this
column-list
- 5 Answers
- 23422 Views
- I also Faced
- E-Mail Answers
Answer Posted / pauline wan
You tried to reference a table using a unique key, but the
column that you listed only have unique index instead of
unique constraint. For example, referenced table called A
has PK column a1, another column a2, a2 has unique index
but not unique constraint, child table B has PK column b1
and another column b2. Now if you want to add FK on
table B column b2 which references table A column a2, you
will get ORA-02270.
To solve the problem, you need to drop unique index on
table A column a2 and create unique constraint on table A
column a2, then add FK on table B column b2.
The tricky is unique index has same functionality as unique
constraint which uniquely identify the data on the column,
but it doesn't have information in user_constraints,
all_constraints,dba_constraints.
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
ORA-26079: file "string" is not part of table string.string
IMG-02003: 2FF03 - incorrect color histogram feature specification
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.
NZE-28868: Peer certificate chain check failed.
if the lengths of two wires are same and the area of cross sections is 4:7 then what will be the ratio of current passing through these wires
ORA-16516: The current state is invalid for the attempted operation.
ORA-26029: index string.string partition string initially in unusable state
when i ran any workflow or session, getting below error: seesion task instance[s_xxx]: Execution terminated unexpecterdly
ORA-26028: index string.string initially in unusable state
ORA-16627: No standby databases support the overall protection mode.
ORA-26030: index string.string had string partitions made unusable due to:
ORA-26094: stream format error: input column overflow
IMP-00096: Warning: Skipping table "string"."string" because type synonym "string"."string" cannot be created
ORA-16626: failed to enable specified object
ORA-26027: unique index string.string partition string initially in unusable state
