CREAT TABLE TABLE1
(
GPS_DATE DATE,
)
PARTITION BY RANGE(GPS_DATE)
INTERVAL(NUMTOYMINTERVAL(1,'MONTH'))
(
PARTITION P1 VALUES LESS THAN(TO_DATE('2014-08-01','YYYY-MM-DD'))
);
将8月的数据存到分区P1,以后每月有数据就会自动创建新的分区。
CREAT TABLE TABLE1
(
GPS_DATE DATE,
)
PARTITION BY RANGE(GPS_DATE)
INTERVAL(NUMTOYMINTERVAL(1,'MONTH'))
(
PARTITION P1 VALUES LESS THAN(TO_DATE('2014-08-01','YYYY-MM-DD'))
);