no matching unique or primary key

[rcanter]

Trying to create a table with a Foreign Key and getting the above error.

The first table creates fine:

CREATE TABLE ORDERS 
 (
    ORDERS_NUM         NUMBER       NOT NULL,
    CUST_NUM           NUMBER       NOT NULL,
    SHIP_STREET        VARCHAR(20)  NOT NULL,
    SHIP_CITY          VARCHAR(20)  NOT NULL,
    SHIP_STATE         VARCHAR(2)   NOT NULL,
    SHIP_ZIP           VARCHAR(5)   NOT NULL,
    SHIP_METHOD        VARCHAR(10)          ,
    ORDER_DATE         DATE         NOT NULL,
    SHIP_DATE          DATE                 ,
    PRIMARY KEY   (ORDERS_NUM, CUST_NUM),
    FOREIGN KEY   (CUST_NUM) REFERENCES CUSTOMER(CUST_NUM)
 );

The second table is where I get the error:

CREATE TABLE ORDERDETAIL
(
    DETAIL_NUM         NUMBER       NOT NULL,
    ORDERS_NUM         NUMBER       NOT NULL,
    PROD_NUM           NUMBER       NOT NULL,
    PROD_PRICE         DEC(10,2)            ,
    PROD_SHIP_COST     DEC(10,2)            ,
    QTY_PURCH          DEC(10,2)    NOT NULL,
    TOT_ORDER_WGHT     DEC(10,2)            ,
    ORDER_STAT	       DEC(10,2)    NOT NULL,
    TOT_PROD_COST      DEC(10,2)            ,
    TAX_RATE_ST        DEC(10,2)            ,
    ORDER_TAX          DEC(10,2)            ,
    TOT_SHIP_COST      DEC(10,2)            ,
    TOT_ORD_COST       DEC(10,2)            ,
    PRIMARY KEY   (DETAIL_NUM),
    FOREIGN KEY   (ORDERS_NUM) REFERENCES ORDERS(ORDERS_NUM),
    FOREIGN KEY   (PROD_NUM) REFERENCES PRODUCT(PROD_NUM)
);

Error is on this line:

    FOREIGN KEY   (ORDERS_NUM) REFERENCES ORDERS(ORDERS_NUM),
                                                 *
ERROR at line 17:
ORA-02270: no matching unique or primary key for this column-list

New to SQL, Can someone please assist? I am using Oracle SQL Plus.

[skhanal]

That is because the primary key on Orders table is ORDERS_NUM, CUST_NUM not just ORDERS_NUM.