在给表加外键引用时，报出 ORA-02270:此列表的唯一或主键不匹配。

点击(此处)折叠或打开

/*==============================================================*/
/* Table: QX_GWYH */
/*==============================================================*/
create table QX_GWYH
(
ID VARCHAR2(32),
RY_DM VARCHAR2(11),
GW_DM VARCHAR2(32)
);
comment on table QX_GWYH is
\'岗位用户表\';
comment on column QX_GWYH.ID is
\'主键\';
comment on column QX_GWYH.RY_DM is
\'人员代码\';
comment on column QX_GWYH.GW_DM is
\'岗位代码\';
/*==============================================================*/
/* Table: QX_RY */
/*==============================================================*/
create table QX_RY
(
RY_DM VARCHAR2(11) not null,
RY_MC VARCHAR2(100),
constraint PK_QX_RY primary key (RY_DM)
);
comment on table QX_RY is
\'人员表\';
comment on column QX_RY.RY_DM is
\'人员代码\';
comment on column QX_RY.RY_MC is
\'人员名称\';
/*==============================================================*/
/* Table: QX_XTYH */
/*==============================================================*/
create table QX_XTYH
(
DLZH VARCHAR2(50) not null,
RY_DM VARCHAR2(11),
PASSWORD VARCHAR2(50),
constraint PK_QX_XTYH primary key (DLZH)
);
comment on table QX_XTYH is
\'用户表\';
comment on column QX_XTYH.DLZH is
\'登录账号\';
comment on column QX_XTYH.RY_DM is
\'人员代码\';
comment on column QX_XTYH.PASSWORD is
\'登录密码\';
alter table QX_GWYH
add constraint FK_QX_GWYH_REFERENCE_QX_XTYH foreign key (RY_DM)
references QX_XTYH (RY_DM);
alter table QX_XTYH
add constraint FK_QX_XTYH_REFERENCE_QX_RY foreign key (RY_DM)
references QX_RY (RY_DM);

问题在于引用表的字段没用唯一约束。

点击(此处)折叠或打开

alter table QX_XTYH
add constraint UK_QX_XTYH_RYDM unique (RY_DM)

ITPub博客

oracle数据库(ORA-02270:此列表的唯一或主键不匹配)

最新文章