I have two tables i'm trying to create with foreign keys.
The statements are below

Book\_Copy Table

```
CREATE TABLE book_copy (
    bid          NUMBER(15) NOT NULL,
    isbn         VARCHAR(15) NOT NULL,
    firstavaib   VARCHAR(9) NOT NULL,
    outservice   VARCHAR(9) NULL,
    CONSTRAINT primary_key PRIMARY KEY ( bid,isbn ),
    FOREIGN KEY ( isbn )
        REFERENCES book_catalog ( isbn )
);

```

History table 

```
CREATE TABLE history (
    bid          NUMBER(15) NOT NULL,
    mid          NUMBER(10) NOT NULL,
    FOREIGN KEY ( mid )
        REFERENCES member ( mid ),
    datetaken    VARCHAR(9) NOT NULL,
    datereturn   VARCHAR(9) NULL,
    FOREIGN KEY ( bid )
        REFERENCES book_copy ( bid ),
    CONSTRAINT primary_key PRIMARY KEY ( bid, datetaken )
);

```

Now when I run it the first one says table created but i get the following for the second. 

```
CREATE TABLE history (
    bid          NUMBER(15) NOT NULL,
    mid          NUMBER(10) NOT NULL,
    FOREIGN KEY ( mid )
        REFERENCES member ( mid ),
    datetaken    VARCHAR(9) NOT NULL,
    datereturn   VARCHAR(9) NULL,
    FOREIGN KEY ( bid )
        REFERENCES book_copy ( bid ),
   CONSTRAINT primary_key PRIMARY KEY ( datetaken )

```

)
 \*
ERROR at line 1:

> 
> ORA-02270: no matching unique or primary key for this column-list
> 
> 
>