建表如下: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
这样改怎么解决啊?求教各位大牛了!