ORALCE对已有数据表进行分区

CREATE TABLE LPB_TRACEPOINT_TEMP_TEST
PARTITION BY RANGE (REPORTTIME) INTERVAL (NUMTODSINTERVAL(1, 'day')) 
(PARTITION PART_T01 VALUES LESS THAN(TO_DATE('2021-06-01', 'yyyy-mm-dd')))
AS
SELECT TP_GUID, PDA_ID, USER_ID, X, Y, LNG, LAT, ANGLE, SPEED, REPORTTIME, TYPE, ACCURACY, SAVE_DATE FROM LPB_TRACEPOINT_TEMP