ALTER TABLE CUSTOMER_DATACONF ADD (
PRIMARY KEY (ID)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
));
改为
ALTER TABLE CUSTOMER_DATACONF ADD CONSTRAINT PK_CUSTOMER_DATACONF PRIMARY KEY (ID)
USING INDEX
TABLESPACE USERS;
PRIMARY KEY (ID)
USING INDEX
TABLESPACE USERS
PCTFREE 10
INITRANS 2
MAXTRANS 255
STORAGE (
INITIAL 64K
MINEXTENTS 1
MAXEXTENTS 2147483645
PCTINCREASE 0
));
改为
ALTER TABLE CUSTOMER_DATACONF ADD CONSTRAINT PK_CUSTOMER_DATACONF PRIMARY KEY (ID)
USING INDEX
TABLESPACE USERS;
应该是
COMMENT ON COLUMN CUSTOMER_DATACONF.CUSTOMER_NAME IS '客户名称'; 2 两个引号都去掉3 有的COMMENT语句有的没加分号改过之后就是正确的代码了