2 qq 15907849 qq_15907849 于 2015.05.27 14:53 提问

SQL 错误: ORA-02270: 此列列表的唯一关键字或主键不匹配

建表如下:create table jt(
Jno int primary key,
Jpassword int not null,
cname int,
Jphone int not null,
Jname varchar(10)
);
create table gt(
account int primary key,
password int not null,
Gname varchar(10),
Gphone int not null
);
create table student(
sno int primary key,
spassword int not null,
class varchar(20) not null,
sname varchar(10) not bull,
sex char,
age int,
home varchar(15),
sphone int not null,
Jno int,
Gname varchar(10)
foreign key (Jno) references jt(Jno),
foreign key (Gname) references gt(Gname)
);
建立外键时出现错误:SQL 错误: ORA-02270: 此列列表的唯一关键字或主键不匹配
02270. 00000 - "no matching unique or primary key for this column-list"
*Cause: A REFERENCES clause in a CREATE/ALTER TABLE statement
gives a column-list for which there is no matching unique or primary
key constraint in the referenced table.
*Action: Find the correct column names using the ALL_CONS_COLUMNS
catalog view

                这样改怎么解决啊?求教各位大牛了!

2个回答

danielinbiti
danielinbiti   Ds   Rxr 2015.05.27 14:57
已采纳

gt表中gname不是主键,外键关联的必须是主键

lzp_lrp
lzp_lrp   Ds   Rxr 2015.05.28 08:34

也有可能是以下错误

1、可能是字段类型不匹配,请先仔细检查,确定无误。
2、关联的主表的主键被锁定

Csdn user default icon
上传中...
上传图片
插入图片