错误码:-2602
错误内容:列存储表[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,
"O_COMMENT" VARCHAR(79)) STORAGE(STAT ASYNCHRONOUS EXCEPT(O_COMMENT), WITH DELTA, SECTION(65536), INITIAL 2, FILESIZE(64), ON "MAIN") LOG LAST ;
[执行语句1]:
CREATE OR REPLACE TRIGGER DEL_TRG
BEFORE DELETE
ON orders
BEGIN
PRINT '您正在对表emp进行删除操作';
END;
执行失败(语句1)
-2602: 第6 行附近出现错误:
列存储表[ORDERS]不能建立触发器
文章
阅读量
获赞