oracle foreign問題-SQL 錯誤: ORA-02270: 此列列表的唯一關鍵字或主鍵不匹配

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

                這樣改怎麼解決啊？求教各位大牛了！

最佳回答：

gt表中gname不是主鍵，外鍵關聯的必須是主鍵