-- Create sequence
create sequence SQ1
minvalue 1
maxvalue 999999999999999999999999999
start with 2001
increment by 1
cache 20;

序列的建立

create table testpatition
(
Gid number(10,3) primary key,
GName varchar2(36),
GDate date
)
partition by range(Gid) 選擇要分區的字段
(
partition p1 values less than(10), 確定分區的范圍
partition p2 values less than(20),
partition p3 values less than(30),
partition p4 values less than(300),
partition p5 values less than(600),
partition p6 values less than (maxvalue)最大分區的數據
);

表分區的建立

declare
n number:=1;
begin
while n<2000 loop
insert into testpatition(gid,GName,Gdate) values(sq1.nextval,n,sysdate);
n:=n+1;
end loop;
end;

測試數據的添加

select * from testpatition partition (p4)

查詢分區的數據的例子

select * from testpatition

查詢所有的數據