Hi, for some reason i cant seem to create this table in oracle 8i. I keep getting an error message

"missing or invalid option"

can anyone help?

Thanks

JAY

CREATE TABLE BOOKINGS
(BOOKING_ID NUMBER(6) CONSTRAINT pk_bookings_booking_id PRIMARY KEY,
BOOKING_DATE DATE,
STOCK_AVAILIBILITY VARCHAR2(3) nn_bookings_stock_availibility NOT NULL,
STAFF_ID NUMBER(4) CONSTRAINT FK_bookings_staff_id REFERENCES STAFF_MEMBER(STAFF_ID),
ACCOUNT_ID NUMBER(6) CONSTRAINT fk_bookings_billing_id REFERENCES BILLING_ACCOUNT(BILLING_ID),
DATE_REQUIRED DATE,
DATE_DUE DATE,
DATE_RETURNED DATE,
CONDITION VARCHAR2(20),
REPAIR_COST NUMBER(6,2),
AMOUNT_DUE NUMBER(6,2));

You missed the word CONSTRAINT here:

STOCK_AVAILIBILITY VARCHAR2(3) CONSTRAINT nn_bookings_stock_availibility NOT NULL,