Oracle创建分区表 *** 作

create table p(id number)

partition by range(id)

(partition p1 values less than(100) tablespace t1,

partition p2 values less than(200) tablespace t2,

partition p3 values less than(300) tablespace t3)

2、添加分区

alter table p add partition p4 values less than (400) tablespace t4

3、清除分区数据

alter table p trunc partition p1

4、删除分区

alter table p drop partition p1

ALTER TABLE AA ADD PARTITION SYS_P421 VALUES LESS THAN(TO_DATE('2017-05-21 00:00:00','YYYY-MM-DD HH24:MI:SS')) TABLESPACE USERS