PT_IOT test
CREATE TABLE BENCHMARK.H_ORDER_IOT_PA
(
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),
orkey number,
constraint pk_paiot primary key (O_ORDERKEY,O_orderdate))
ORGANIZATION INDEX
PARTITION BY RANGE (O_orderdate)
(PARTITION P1
VALUES LESS THAN (TO_DATE ('1994-1-1', 'YYYY-MM-DD')),
PARTITION P2
VALUES LESS THAN (TO_DATE ('1996-1-1', 'YYYY-MM-DD')),
PARTITION P3
VALUES LESS THAN (TO_DATE ('1998-1-1', 'YYYY-MM-DD')),
PARTITION P4
VALUES LESS THAN (MAXVALUE));
exec DBMS_REDEFINITION.can_redef_table ('benchmark', 'h_order_IOT');
exec DBMS_REDEFINITION.abort_redef_table('benchmark','h_order_IOT','h_order_pA');
exec DBMS_REDEFINITION.start_redef_table ('benchmark','h_order_IOT','h_order_IOT_pA');
SELECT COUNT(*)
FROM h_order_IOT_PA
WHERE O_orderdate > TO_DATE ('1998-1-1', 'YYYY-MM-DD')
ORDER BY o_orderdate;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16348200/viewspace-541626/ ，如需转载，请注明出处，否则将追究法律责任。
