oracle 分区

普通字段分区
create table JBPM7_TASK
(
task_id VARCHAR2(64) not null,
exe_id VARCHAR2(64) not null,
def_id VARCHAR2(64) not null,
create_time VARCHAR2(32) default to_char(sysdate,’YYYY-MM-DD HH24:MI:SS’) not null
)partition by range (create_time)
(
partition p_201601 values less than (‘2017-01-01’),
partition p_201701 values less than (‘2018-01-01’),
partition p_201801 values less than (‘2019-01-01’)
);

如果字段为date类型，可以自动按照时间分区，
create table JBPM8_TASK
(
task_id VARCHAR2(64) not null,
exe_id VARCHAR2(64) not null,
def_id VARCHAR2(64) not null,
create_time DATE
)partition by range (create_time) INTERVAL(NumToYMInterval(1, ‘YEAR’))
(
partition p2016 values less than (to_date(‘2017-01-01’,’YYYY-MM-DD’))

);

分区的意思是2017-01-01之前的数据会给p2016,其余按照年份，一年一年增加分区