Oracle 8i lite. Problems with Foreign Key on TIME and DATE type columns

[Quoted] I'm using oracle 8i lite, for a university project, and I have a problem with a single foreign key.

I receive this error message:

OCA-30035: column not found
[POL-5205] column not found

When I try to set the foreign key

ALTER TABLE booking ADD
(CONSTRAINT fk_booking
FOREIGN KEY (date, time, room)
REFERENCES show(date, time, room));

between these tables

CREATE TABLE booking(
id_customer VARCHAR(6),
date DATE,
time TIME,
room VARCHAR(20),
PRIMARY KEY (id_customer, date, time, room)
);

CREATE TABLE show(
date DATE,
time TIME,
room VARCHAR(20),
movie VARCHAR(6),
PRIMARY KEY (date, time, room)
);

Thanks Received on Thu Jun 12 2003 - 16:37:19 CEST