Constraint problem

I have created the following tables

create table complex (
 cacc# number not null primary key,
 cname varchar2(40) not null unique,
 pre# number,
);

create table c_ref (
 cacc# number not null,
 ref# number not null,
 primary key (cacc#,ref#)
);

Then i want to add the following constraint

SQL> alter table proteincomplex
  2 add constraint c_cacc#_fk
  3 foreign key (cacc#)
  4 references c_ref (cacc#);

But I get the error message: ORA-02270: no matching unique or primary key for this column-list
Can anyone tell me why and how to solve this problem?

Thanks

Svenn. Received on Wed May 24 2000 - 00:00:00 CEST