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

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

点击(此处)折叠或打开

1. /*==============================================================*/
   
2. /* Table: QX_GWYH */
   
3. /*==============================================================*/
   
4. create table QX_GWYH
   
5. (
   
6.    ID VARCHAR2(32),
   
7.    RY_DM VARCHAR2(11),
   
8.    GW_DM VARCHAR2(32)
   
9. );
   
10. 
    
11. comment on table QX_GWYH is
    
12. \'岗位用户表\';
    
13. 
    
14. comment on column QX_GWYH.ID is
    
15. \'主键\';
    
16. 
    
17. comment on column QX_GWYH.RY_DM is
    
18. \'人员代码\';
    
19. 
    
20. comment on column QX_GWYH.GW_DM is
    
21. \'岗位代码\';
    
22. 
    
23. /*==============================================================*/
    
24. /* Table: QX_RY */
    
25. /*==============================================================*/
    
26. create table QX_RY
    
27. (
    
28.    RY_DM VARCHAR2(11) not null,
    
29.    RY_MC VARCHAR2(100),
    
30.    constraint PK_QX_RY primary key (RY_DM)
    
31. );
    
32. 
    
33. comment on table QX_RY is
    
34. \'人员表\';
    
35. 
    
36. comment on column QX_RY.RY_DM is
    
37. \'人员代码\';
    
38. 
    
39. comment on column QX_RY.RY_MC is
    
40. \'人员名称\';
    
41. 
    
42. /*==============================================================*/
    
43. /* Table: QX_XTYH */
    
44. /*==============================================================*/
    
45. create table QX_XTYH
    
46. (
    
47.    DLZH VARCHAR2(50) not null,
    
48.    RY_DM VARCHAR2(11),
    
49.    PASSWORD VARCHAR2(50),
    
50.    constraint PK_QX_XTYH primary key (DLZH)
    
51. );
    
52. 
    
53. comment on table QX_XTYH is
    
54. \'用户表\';
    
55. 
    
56. comment on column QX_XTYH.DLZH is
    
57. \'登录账号\';
    
58. 
    
59. comment on column QX_XTYH.RY_DM is
    
60. \'人员代码\';
    
61. 
    
62. comment on column QX_XTYH.PASSWORD is
    
63. \'登录密码\';
    
64. 
    
65. 
    
66. 
    
67.    
    
68. alter table QX_GWYH
    
69.    add constraint FK_QX_GWYH_REFERENCE_QX_XTYH foreign key (RY_DM)
    
70.       references QX_XTYH (RY_DM);
    
71. 
    
72. alter table QX_XTYH
    
73.    add constraint FK_QX_XTYH_REFERENCE_QX_RY foreign key (RY_DM)
    
74.       references QX_RY (RY_DM);

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

点击(此处)折叠或打开

1. alter table QX_XTYH
   
2.    add constraint UK_QX_XTYH_RYDM unique (RY_DM)

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/30066956/viewspace-1369791/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/30066956/viewspace-1369791/