oracle表分区

--列表分区
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';