Re: Foreign Key Problem

From: Helmut Hahn <Helmut.Hahn_at_bitoek.uni-bayreuth.de>
Date: 1998/02/20
Message-ID: <34ED7F2B.3EFE58C6@bitoek.uni-bayreuth.de>#1/1

DINFA - Microcentro wrote:

...

> i.e. only the Columns T2Cod1 and T2Cod3 From Table2 are the Key
> Components of Foreign Key.
> When i try this an error occurs
> ORA-02270: No matching unique or Primary Key for this Column List.
>
> Is there any way to do that.
>
> Thanks in Advence
> Joe

I think you only must generate an unuique Index with columns T2Cod1 and T2Cod3. From the RDM this is absolutely
clear and neccessary to assure dataintegrity. Hope this helps.

Helmut

www.bitoek.uni-bayreuth.de Received on Fri Feb 20 1998 - 00:00:00 CST