Experts,
We have a table as emp which has emp_no, mobile_no,address_id colums in compound primary key. But whenever i wish to add emp_no in while creating Emp_address table as Foreign key it is errored . When i add all three columns as foreign key then able to create table. Is there any way only add emp_no as foreign key. Please suggest us.
ORA-02270: No matching unique or Primary key for this column list.
Class : A references clause in a created or Alter table statement gives a column list for which there is no matching unique or primary key constraint in the reference table.
Thanks & Regards.
JP