oracle 分区表的建立

/sys_imp_log 分区表建立/

alter table sys_imp_log drop partition PART_T201600 UPDATE GLOBAL INDEXES;

alter table sys_imp_log rename partition PART_T201601 to PART_T201512;

alter table sys_imp_log add PARTITION PART_T201601 VALUES LESS THAN (TIMESTAMP ‘2016-02-01 00:00:00’) TABLESPACE EBUS;
alter table sys_imp_log add PARTITION PART_T201602 VALUES LESS THAN (TIMESTAMP ‘2016-03-01 00:00:00’) TABLESPACE EBUS;
alter table sys_imp_log add PARTITION PART_T201603 VALUES LESS THAN (TIMESTAMP ‘2016-04-01 00:00:00’) TABLESPACE EBUS;
alter table sys_imp_log add PARTITION PART_T201604 VALUES LESS THAN (TIMESTAMP ‘2016-05-01 00:00:00’) TABLESPACE EBUS;
alter table sys_imp_log add PARTITION PART_T201605 VALUES LESS THAN (TIMESTAMP ‘2016-06-01 00:00:00’) TABLESPACE EBUS;
alter table sys_imp_log add PARTITION PART_T201606 VALUES LESS THAN (TIMESTAMP ‘2016-07-01 00:00:00’) TABLESPACE EBUS;
alter table sys_imp_log add PARTITION PART_T201607 VALUES LESS THAN (TIMESTAMP ‘2016-08-01 00:00:00’) TABLESPACE EBUS;
alter table sys_imp_log add PARTITION PART_T201608 VALUES LESS THAN (TIMESTAMP ‘2016-09-01 00:00:00’) TABLESPACE EBUS;
alter table sys_imp_log add PARTITION PART_T201609 VALUES LESS THAN (TIMESTAMP ‘2016-10-01 00:00:00’) TABLESPACE EBUS;
alter table sys_imp_log add PARTITION PART_T201610 VALUES LESS THAN (TIMESTAMP ‘2016-11-01 00:00:00’) TABLESPACE EBUS;
alter table sys_imp_log add PARTITION PART_T201611 VALUES LESS THAN (TIMESTAMP ‘2016-12-01 00:00:00’) TABLESPACE EBUS;
alter table sys_imp_log add PARTITION PART_T201712 VALUES LESS THAN (TIMESTAMP ‘2017-01-01 00:00:00’) TABLESPACE EBUS;

alter table sys_imp_log add PARTITION PART_T201700 VALUES LESS THAN (MAXVALUE) TABLESPACE EBUS;这里写代码片