oracle表分区
来源:互联网 发布:淘宝小本生意囤货 编辑:程序博客网 时间:2024/06/07 21:04
--列表分区
create table person2(name varchar(20),sex char(2))
partition by list (sex)
(
partition p1 values ('男'),
partition p2 values ('女')
);
insert into person2 values ('aaa','男');
insert into person2 values('bbb','女');
select * from person2 partition (p2);
--添加表分区
alter table person2 add partition p3 values (default);
--删除表分区
alter table person2 drop partition p3;
--散列分区
create table person3(name varchar(20),sex char(2))
partition by hash (name)
partitions 2;
insert into person3 values ('aaa','男');
insert into person3 values('bbb','女');
select * from person3 partition (SYS_P768);
--范围-列表分区
create table person4(name varchar(20),sex char(2),birth date)
partition by range (birth)
subpartition by list (sex)
subpartition template
(
subpartition sp1 values ('男'),
subpartition sp2 values ('女'),
subpartition sp3 values (default)
)
(
partition p1 values less than (to_date('19900101', 'yyyymmdd')),
partition p2 values less than (to_date('20000101', 'yyyymmdd')),
partition p3 values less than (maxvalue)
);
insert into person4 values ('aaa','男',to_date('19900202','yyyymmdd'));
insert into person4 values('bbb','女',to_date('20100202','yyyymmdd'));
select * from person4 subpartition(p2_sp1);
drop table person4;
select * from user_objects where object_name ='PERSON4';
select * from user_tables where table_name = 'PERSON4';
select * from user_tab_subpartitions where table_name = 'PERSON4';
select * from user_tab_subpartitions where table_name = 'PERSON4';
create table person2(name varchar(20),sex char(2))
partition by list (sex)
(
partition p1 values ('男'),
partition p2 values ('女')
);
insert into person2 values ('aaa','男');
insert into person2 values('bbb','女');
select * from person2 partition (p2);
--添加表分区
alter table person2 add partition p3 values (default);
--删除表分区
alter table person2 drop partition p3;
--散列分区
create table person3(name varchar(20),sex char(2))
partition by hash (name)
partitions 2;
insert into person3 values ('aaa','男');
insert into person3 values('bbb','女');
select * from person3 partition (SYS_P768);
--范围-列表分区
create table person4(name varchar(20),sex char(2),birth date)
partition by range (birth)
subpartition by list (sex)
subpartition template
(
subpartition sp1 values ('男'),
subpartition sp2 values ('女'),
subpartition sp3 values (default)
)
(
partition p1 values less than (to_date('19900101', 'yyyymmdd')),
partition p2 values less than (to_date('20000101', 'yyyymmdd')),
partition p3 values less than (maxvalue)
);
insert into person4 values ('aaa','男',to_date('19900202','yyyymmdd'));
insert into person4 values('bbb','女',to_date('20100202','yyyymmdd'));
select * from person4 subpartition(p2_sp1);
drop table person4;
select * from user_objects where object_name ='PERSON4';
select * from user_tables where table_name = 'PERSON4';
select * from user_tab_subpartitions where table_name = 'PERSON4';
select * from user_tab_subpartitions where table_name = 'PERSON4';
阅读全文
0 0
- Oracle表分区、索引分区
- Oracle表分区:范围分区
- Oracle.表分区:列表分区
- Oracle.表分区:复合分区
- ORACLE表分区
- oracle大表分区
- ORACLE表分区
- Oracle表分区
- Oracle表分区
- oracle(表分区技术)
- oracle 表空间/分区
- Oracle 创建表分区
- oracle 表分区
- oracle表分区
- Oracle表分区
- Oracle表分区
- oracle 物理表 分区
- oracle表分区详解
- Tomcat相关
- 【并查集模板】洛谷P3367
- Eclipse基本操作(一)设置Servlet模板、设置Java项目自动进入Tomcat中webapps下
- Complex复数类
- 解析Vin码识别-车架号识别的识别过程
- oracle表分区
- Java中对类中的属性使用set/get方法的意义和用法
- NLPIR_ImportUserDict()函数用户字典导入失败
- 工作日常问题10个
- 1109. Group Photo (25)
- (一)Unity3D 2017 下载安装(配合VS 2017)
- Vue + ElementUI 手撸后台管理网站基本框架(三)登录及系统菜单加载
- matlab 关于取整函数 fix, floor, ceil, round
- 用Jquery获取iframe父页面元素