Answer / sangam

ORA-02270: no matching unique or primary key for this
column-list

This error also occurs when we try to add a foreign key
constraint to a table and there does not exist primary key
in the referenced table or the column being referenced is
not a promary key.

http://dotnetspidor.blogspot.com

Answer / guest

Cause: A REFERENCES clause in a CREATE/ALTER TABLE statement
gives a column-list for which there is no matching unique or
primary key constraint in the referenced table.

Action: Find the correct column names using the
ALL_CONS_COLUMNS catalog view

Please add more information about this Error

Answer / 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.

Answer / jay

please u can check your primary key field

after set unique yes

Answer / chetan

CAUSE:You tried to reference a table using a unique or
primary key, but the columns that you listed did not match
the primary key, or a primary key does not exist for this
table.
SOL:
This error commonly occurs when you try to create a foreign
key that references a table that doesn't have a primary
key. To resolve this problem, create a primary key on the
referenced table. Then re-execute your command to create
the foreign key.

TNS-00210: Total Pumps Available : number

1 Answers  

---

ORA-16089: archive log has already been registered

1 Answers  

---

PCC-02369: An EXEC TOOLS host pointer variable is not a pointer

1 Answers  

---

PLS-00568: cannot access rows from a non-nested table item

1 Answers  

---

ORA-33450: (ESDREAD05) Discarding compiled code for workspace object because number now has more or fewer dimensions than it had when the code was compiled.

1 Answers  

---

---

ORA-02281: duplicate or conflicting CACHE/NOCACHE specifications

1 Answers  

---

ORA-16036: invalid MANAGED recovery CANCEL option

1 Answers  

---

DRG-50701: error in listener.get_cmd()

1 Answers  

---

ORA-30175: invalid type given for an argument

1 Answers  

---

ORA-12070: cannot offline instantiate materialized view "string"."string"

1 Answers  

---

RMAN-08112: archivelog failover was done on string, check alert log for more info

1 Answers  

---

ORA-39952: only numbers can be specified as range values

1 Answers  

---