Hush分区的相关操作

一、HASH分区表的创建、插入，查询，删除

1. 创建HASH分区表

create table graderecord  

(  

  sno varchar2(10),  

  sname varchar2(20),  

  dormitory varchar2(3),  

  grade int  

)  

partition by hash(sno)  

(  

  partition p1,  

  partition p2,  

  partition p3,

  partition p4);

1. 1. 查看分区表是否存在

select TABLE_NAME from dba_tab_partitions where table_name='GRADERECORD';

1.2 查看分区表中分区个数

select table_name,partition_name from dba_tab_partitions where table_name='FUT_FQB_ZJ';

2、插入数据：

insert into graderecord values('511601','魁','229',92);  

insert into graderecord values('511602','凯','229',62);  

insert into graderecord values('511603','东','229',26);  

insert into graderecord values('511604','亮','228',77);  

insert into graderecord values('511605','敬','228',47);  

insert into graderecord(sno,sname,dormitory) values('511606','峰','228');  

Commit;

3、查询分区表

select * from graderecord ;

select * from graderecord partition(p1);  

select * from graderecord partition(p2);  

select * from graderecord partition(p3);

进行创建，插入，查询，删除HASH分区,并进行查看

 

4、删除分区并进行查看

 

二、HASH分区表分区管理

1、增加分区

alter table graderecord add partition p5;

select * from graderecord partition(p5);

1.1 查看分区表是否存在

select TABLE_NAME from dba_tab_partitions where table_name='GRADERECORD';

1.2 查看分区表中分区名

select table_name,partition_name from dba_tab_partitions where table_name='GRADERECORD';

select * from graderecord partition(p5);

1.3 插入数据：

insert into graderecord values('511607','明','240',90);  

insert into graderecord values('511608','楠','240',100);  

insert into graderecord values('511609','涛','240',67);  

insert into graderecord values('511610','博','240',75);  

insert into graderecord values('511611','铮','240',60);

Commit;

select * from graderecord partition(p4);

2、truncate 分区，并进行查看

alter table graderecord truncate partition p4;

select count(*) from graderecord partition(p4);

 

达梦数据库 - 新一代大型通用关系型数据库 | 达梦云适配中心