IOT test
SELECT *
FROM h_order
WHERE O_orderdate > TO_DATE ('1998-1-1', 'YYYY-MM-DD')
ORDER BY o_orderdate;
CREATE TABLE BENCHMARK.H_ORDER_IOT
(
O_ORDERKEY NUMBER NOT NULL,
O_CUSTKEY NUMBER NOT NULL,
O_ORDERSTATUS CHAR (1 BYTE),
O_TOTALPRICE NUMBER,
O_ORDERDATE DATE,
O_ORDERPRIORITY CHAR (15 BYTE),
O_CLERK CHAR (15 BYTE),
O_SHIPPRIORITY NUMBER,
O_COMMENT VARCHAR2 (79 BYTE),
CONSTRAINT H_ORDER_R02 PRIMARY KEY (O_ORDERKEY)
)
ORGANIZATION INDEX;
exec DBMS_REDEFINITION.can_redef_table ('benchmark', 'h_order');
exec DBMS_REDEFINITION.start_redef_table ('benchmark','h_order','h_order_iot');
exec DBMS_REDEFINITION.sync_interim_table('benchmark', 'h_order', 'h_order_iot');
exec DBMS_REDEFINITION.finish_redef_table('benchmark', 'h_order', 'h_order_iot');
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16348200/viewspace-541622/ ，如需转载，请注明出处，否则将追究法律责任。
