oracle分区表基本操作

 1,分区表增加分区

alter table table_name 
add partition t20050101 values less than(to_date('2005-01-01','yyyy-mm-dd')) tablespace tablespace_name;

 

2,分区表删除分区
alter table table_name drop partition t20050101;

 

3,分区表合并分区

alter table table_name merge partitions t20050101,t20060101 into partition t20060101;

 

4,查询表分区纪录数

select count(1) from table_name partition(t20050101);

 

5,更新表分区数据

update table_name partition(t20050101) t set t.name='Java' where t.id=20;

 

6,删除表分区数据

delete from table_name partition(t20050101) t where t.id=20;