分区表创建

范围分区表创建：

create table part_test(id int,name varchar2(50))
partition by range(id)
(
 partition part_1 values less than(10) tablespace xxx,
 partition part_2 values less than(20) tablespace xxx,
 partition part_3 values less than(maxvalue) tablespace xxx
);

hash分区表创建：

create table part_test(id int,name varchar2(50))
partition by hash(id)
(
 partition part_1  tablespace xxx,
 partition part_2  tablespace xxx,
 partition part_3  tablespace xxx
);

 

列表分区表创建

create table part_test(id int,name varchar2(50))
partition by list(name)
(
 partition part_1 values (part1) tablespace xxx,
 partition part_2 values (part2) tablespace xxx,
 partition part_3 values (part3) tablespace xxx
);

 

复合分区表创建

create table part_test(id int,name varchar2(50))
partition by range(id) subpartition by hash(name)
(
 partition part_1 values less than(10) tablespace xxx,
 partition part_2 values less than(20) tablespace xxx,
 partition part_3 values less than(maxvalue) tablespace xxx
);

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/16546776/viewspace-687401/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/16546776/viewspace-687401/