ORA-00922: 选项缺失或无效,oracle,为何,版本10.2 登录数据库主页后创建的脚本,我是菜鸟,请教
CREATE TABLE "EQINFO"
( "DIVNUM" NUMBER NOT NULL ENABLE,
"DIVNAME" CHAR(100) NOT NULL ENABLE,
"ADDNUM" CHAR(100) NOT NULL ENABLE,
"DIVTYPE" CHAR(100) NOT NULL ENABLE,
"DIVMODEL" CHAR(100) NOT NULL ENABLE,
"SUPPELS" CHAR(100) NOT NULL ENABLE,
"DIVSTATUS" CHAR(100) NOT NULL ENABLE,
"DIVIMAGE" BLOB NOT NULL ENABLE,
"MOVABLE" CHAR(100) NOT NULL ENABLE
)
CREATE TABLE "LOCINFO"
( "ADDNUM" CHAR(100) NOT NULL ENABLE,
"ADDNAME" CHAR(100) NOT NULL ENABLE
)
CREATE TABLE "EQHIERARCHY"
( "DIVNUM" NUMBER NOT NULL ENABLE,
"FDIVNUM" NUMBER NOT NULL ENABLE
)
CREATE TABLE "LOCHIERARCHY"
( "ADDNUM" CHAR(100) NOT NULL ENABLE,
"FADDNUM" CHAR(100) NOT NULL ENABLE
)
/
补充:错了,我把那些点补上了,又出现错误ORA-00904: : 标识符无效