SQL code problem

From: Arun Solleti <asolleti_at_csee.usf.edu>
Date: 2000/06/21
Message-ID: <3950E079.24B18120_at_csee.usf.edu>#1/1

[Quoted] 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 (
[Quoted]   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 Received on Wed Jun 21 2000 - 00:00:00 CEST