错误码：-2668
错误内容：无效的表[ORDERS]约束
错误级别: ERROR
原因：HUGE表不支持添加约束

CREATE HUGE TABLE "SYSDBA"."ORDERS"
(
"O_ORDERKEY" INT,
"O_CUSTKEY" INT,
"O_ORDERSTATUS" CHAR(1),
"O_TOTALPRICE" FLOAT,
"O_ORDERDATE" DATE,
"O_ORDERPRIORITY" CHAR(15),
"O_CLERK" CHAR(15),
"O_SHIPPRIORITY" INT,
11  "O_COMMENT" VARCHAR(79)) STORAGE(STAT ASYNCHRONOUS EXCEPT(O_COMMENT), WITH DELTA, SECTION(65536), INITIAL 2, FILESIZE(64), ON "MAIN")  LOG LAST ;
操作已执行
已用时间: 67.714(毫秒). 执行号:600.
SQL> 
SQL> 
SQL> 
SQL> ALTER TABLE ORDERS ADD CHECK (O_ORDERKEY >10)
2   ;
ALTER TABLE ORDERS ADD CHECK (O_ORDERKEY >10)
;
第2 行附近出现错误[-2668]:无效的表[ORDERS]约束.
已用时间: 0.781(毫秒). 执行号:0.
SQL>