没有与此SQL匹配的唯一键或主键 [英] no matching unique or primary key for this SQL

问题描述

我正在尝试编写这段代码

I'm trying to write this code

CREATE TABLE BOOK
(BOOKNO NUMBER(4) PRIMARY KEY NOT NULL,
BTIME NUMBER(24,22),
CNAME VARCHAR2(10) ,
BTYPE VARCHAR2(13),
TABLENO NUMBER(2),
EMPNO NUMBER(4),
ENAME VARCHAR2(10),
BDATE  DATE DEFAULT '23-MAR-13',
FOREIGN KEY (CNAME) REFERENCES BOOK (CNAME));

但是它告诉我创建我的前例键时出现此错误

but it shows me that I have this error for creating my foregin key

第10行出现错误:
ORA-02270:此列列表没有匹配的唯一键或主键

ERROR at line 10:
ORA-02270: no matching unique or primary key for this column-list

推荐答案

Oracle/PLSQL:ORA-02270错误

您尝试使用唯一键或主键引用表，但是您列出的列与主键不匹配，或者该表不存在主键.

You tried to reference a table using a unique or primary key, but the columns that you listed did not match the primary key, or a primary key does not exist for this table.

CREATE TABLE BOOK
(BOOKNO NUMBER(4) PRIMARY KEY NOT NULL,
BTIME NUMBER(24,22),
CNAME VARCHAR2(10) ,
BTYPE VARCHAR2(13),
TABLENO NUMBER(2),
EMPNO NUMBER(4),
ENAME VARCHAR2(10),
BDATE  DATE DEFAULT '23-MAR-13',
FOREIGN KEY (CNAME) REFERENCES BOOK (BOOKNO));

更新

CREATE TABLE BOOK
    (BOOKNO NUMBER(4) PRIMARY KEY NOT NULL,
    BTIME NUMBER(24,22),
    CNAME VARCHAR2(10) NOT NULL UNIQUE,
    BTYPE VARCHAR2(13),
    TABLENO NUMBER(2),
    EMPNO NUMBER(4),
    ENAME VARCHAR2(10),
    BDATE  DATE DEFAULT '23-MAR-13',
    FOREIGN KEY (CNAME) REFERENCES BOOK (CNAME));

这篇关于没有与此SQL匹配的唯一键或主键的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！