Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004
    Location
    London
    Posts
    8

    Error Message While Creating A Table

    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));

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171

    Re: Error Message While Creating A Table

    You missed the word CONSTRAINT here:

    STOCK_AVAILIBILITY VARCHAR2(3) CONSTRAINT nn_bookings_stock_availibility NOT NULL,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •