design problem with fk part of pk in oracle env

hi folks,

I've designed some tables and a relationship between them

/ *=================================================

/ *=================================================

FREQUENZ_EINHEIT VARCHAR2(3),
ZEITRAUM_AB DATE,
ZEITRAUM_BIS DATE,

/ *=================================================

/ *=================================================

create table ZINSSATZ (
ID_ZINSSATZ INTEGER not null,
UPDATE_NO NUMBER(5) not null,
ZINSSATZ NUMBER(9,6),
QUOTIERUNGSZEIT DATE,
UEBERNAHMEZEIT DATE,
ID_KURSART INTEGER not null,
ID_RIC_REFERENZZINS INTEGER not null,
USER_IK NUMBER(5),
REC_STATUS VARCHAR2(1),
VALID_FROM DATE,
VALID_TO DATE
)
/

/ *=================================================

/ *=================================================

alter table ZINSSATZ
add constraint FK_ZINSSATZ_RELATIONS_RIC_REFE foreign key (ID_RIC_REFERENZZINS)
references RIC_REFERENZZINS (ID_RIC_REFERENZZINS) /

• ****************** Error ************************************** --
• references RIC_REFERENZZINS (ID_RIC_REFERENZZINS)
• *
• ERROR at line 3:
• ORA-02270: no matching unique or primary key for this column-list

how to work around it in an Oracle enviroment as of 8.1.7.4 on Sun Solaris 2.8

table zinsatz
id_zinssatz is incremented by a sequence and for id_zinssatz there several updates though in the referenced table I only want the id_zinssatz referenced ...

p.s. as for sybase design it works properly but not for ORCL why???

any help highly appreciated
Thanks

--
Posted via http://dbforums.com