Re: SQL Help

From: <sergey_s_at_my-deja.com>
Date: 2000/06/21
Message-ID: <8ir4en$knc$1@nnrp1.deja.com>#1/1

You must reference the entire key of ACCESSLEVEL in your foreign key constraint:

... references ACCESSLEVEL(ACCESSID, TRANSACTIONID) ... CASCADE

hth

Sergey

In article <3950E031.2089DCBE_at_csee.usf.edu>,   @cisco.com wrote:
> Can any one help me out with this code. I am trying to create two
 tables
> which are below :
>
> CREATE TABLE ACCESSLEVEL(
> ACCESSID VARCHAR2(30) NOT NULL,
> TRANSACTIONID NUMBER(10) NOT NULL,
> NAME VARCHAR2(30) NOT NULL,
> CONSTRAINT PK_ACCESSLEVEL_ACCESSID_T
> PRIMARY KEY (ACCESSID, TRANSACTIONID)
> );
>
>

 /**********************************************************************/

>
> CREATE TABLE LABUSER (
> USERID VARCHAR2(30) NOT NULL CONSTRAINT PK_LABUSER_USERID PRIMARY
 KEY,
>
> ACCESSID VARCHAR2(30) NOT NULL
> CONSTRAINT FK_LABUSER_ACCESSID references
> ACCESSLEVEL(ACCESSID) ON DELETE CASCADE);
>

 /**********************************************************************/

>
> When i execute this it is giving me the following error
>

 /**********************************************************************/

>
> Table created.
>
> ACCESSLEVEL(ACCESSID) ON DELETE
 CASCADE)
>
> *
> ERROR at line 5:
> ORA-02270: no matching unique or primary key for this column-list
>

 /**********************************************************************/

>
> I am able to create accesslevel, which has a composite key comprising
> accessid and transcationid, but i do not know why labuser is not able
 to
> have relation with accessid.
>
> Arun
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jun 21 2000 - 00:00:00 CDT