create table log_tab (
log_ind NUMBER,
col1 NUMBER,
...
log_date DATE)
PARTITION BY RANGE(sales_date)
(
PARTITION log_date1 VALUES LESS THAN(TO_DATE('01','DD')),
PARTITION log_date2 VALUES LESS THAN(TO_DATE('02','DD')),
...
PARTITION log_date2 VALUES LESS THAN(TO_DATE('12','DD'))
);
上面以天作为分区,如何以一年中的每天进行分区?
|