PT test
CREATE TABLE BENCHMARK.H_ORDER_PA
(
O_ORDERKEY NUMBER PRIMARY KEY 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)
)
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.start_redef_table ('benchmark','h_order_IOT','h_order_pa');
SELECT COUNT(*)
FROM h_order_PA
WHERE O_orderdate > TO_DATE ('1998-1-1', 'YYYY-MM-DD')
ORDER BY o_orderdate;
SELECT COUNT(*) FROM h_order_PA PARTITION (P1);
SELECT COUNT(*) FROM h_order_PA PARTITION (P2);
SELECT COUNT(*) FROM h_order_PA PARTITION (P3);
SELECT COUNT(*) FROM h_order_PA PARTITION (P4);
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/16348200/viewspace-541624/ ，如需转载，请注明出处，否则将追究法律责任。
