创建表分区：

SQL> create table t_part(id int)

 2 partition by range(id)

 3 (partition p1 values less than(5),

 4 partition p2 values less than(10),

 5  partition pmax values less than(maxvalue)

 6  );

查询表分区：

SQL> select * from t_part;

 SQL>select * from t_part partition(p1);

SQL> select * from t_part partition(p2);

SQL> select * from t_part partition(pmax);

删除分区：

SQL> alter table t_part drop partition p1;