我试图在Oracle SQL开发人员中创建一个表和一个索引,但我不断收到错误:
错误报告 - SQL错误:ORA-00942:表或视图不存在00942. 00000 - “表或视图不存在”*原因:*操作:
我的陈述:
CREATE TABLE TAB_ATTRIBUTES_OF_RELATIONSHIP
(
REL_NAME VARCHAR(15) not null,
ATTR_NAME VARCHAR(15) not null,
ATTREL_DATATYPE VARCHAR(15) not null,
ATTREL_DOMAIN VARCHAR(20),
constraint PK_ATTRIBUTES_OF_RELATIONSHIP primary key (REL_Name, ATTR_NAME),
constraint FK_ATTRIBUTES_OF_RELATIONSHIP foreign key (REL_NAME)
references RELATIONSHIPS (REL_NAME)
constraint FK_ATTRIBUTES_OF_RELATIONSHIP foreign key (ATTR_NAME)
references ATTRIBUTES (ATTR_NAME),
);
/* Index: IDX_ATTRIBUTES_OF_RELATIONSHIP */
Create index IDX_ATTRIBUTES_OF_RELATIONSHIP_FK on Tab_ATTRIBUTES_OF_RELATIONSHIP
(
ATTR_NAME ASC
);
1 回答
问题似乎与
CREATE TABLE
语句有关 . 您应该注意放置逗号的位置,并尝试逐步执行脚本这是表创建语句的更正版本