在给表加外键引用时,报出 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博客 ” ,链接:http://blog.itpub.net/30066956/viewspace-1369791/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/30066956/viewspace-1369791/