ORA-00904: invalid identifier error with Foreign Keys [message #310750] |
Wed, 02 April 2008 05:11  |
samwij
Messages: 2 Registered: April 2008 Location: Melbourne, Australia
|
Junior Member |
|
|
Hi, I am new to SQL and am doing a course in Relational Databases. I am creating a series of tables however I get 'Invalid Identifier' messages when creating my tables with a Foreign Key. If someone could shed some lights on this issue it would be greatly appreciated:
The Foreign Key - TEAMNO is invalid but I dont know why:
CREATE TABLE TEAM
(
TeamNo NUMBER(4,1) NOT NULL,
TeamName VARCHAR2(30),
PRIMARY KEY (TeamNo)
);
CREATE TABLE PURCHASER
(
PFirstName VARCHAR2(30) NOT NULL,
PSurname VARCHAR2(30) NOT NULL,
Address VARCHAR2(3) NOT NULL,
PRIMARY KEY (PFirstName, PSurname)
);
CREATE TABLE INFORMATION_SESSION
(
SessNo NUMBER(4,1),
SessTitle VARCHAR2(30) NOT NULL,
Duration VARCHAR2(30) NOT NULL,
Price NUMBER(4,2) NOT NULL,
PRIMARY KEY (SessNo),
FOREIGN KEY (TeamNo) REFERENCES TEAM
);
CREATE TABLE STUDENT
(
StuId NUMBER(4,1),
SFirstName VARCHAR2(30) NOT NULL,
SSurname VARCHAR2(30) NOT NULL,
Gender VARCHAR(30) NOT NULL,
PRIMARY KEY (StuId),
FOREIGN KEY (TeamNo) REFERENCES TEAM);
CREATE TABLE TICKET
(
TicketNumber NUMBER(4,1),
PRIMARY KEY (TicketNumber),
FOREIGN KEY (SessNo) REFERENCES INFORMATION_SESSION,
FOREIGN KEY (PFirstName, PSurname) REFERENCES PURCHASER
);
|
|
|
|
|
|