oracle数据库建立表分区

--oracle 创建分区表；
CREATE TABLE RangeTable ( 
	idd INT PRIMARY KEY, 
	iNAME VARCHAR ( 10 ), 
	grade INT ) 
PARTITION BY RANGE ( grade ) 
( 
	PARTITION part1 VALUES LESS THAN ( 3 ), 
  PARTITION part2 VALUES LESS THAN ( MAXVALUE ) 
);

-- 查看当前用户的分区表信息；
select * from user_tab_partitions where table_name ='RangeTable';

--插入数据
insert into RangeTable  values(1,'zhangsan1',13);
insert into RangeTable  values(2,'zhangsan2',13);
insert into RangeTable  values(3,'zhangsan3',13);
insert into RangeTable  values(4,'zhangsan4',13);
insert into RangeTable  values(5,'zhangsan5',13);
insert into RangeTable  values(6,'zhangsan6',13);
insert into RangeTable  values(7,'zhangsan6',3);
insert into RangeTable  values(8,'zhangsan6',3);
insert into RangeTable  values(9,'zhangsan6',3);
insert into RangeTable  values(10,'zhangsan6',2);
insert into RangeTable  values(11,'zhangsan6',2);

-- 查询
select * from RangeTable PARTITION(part1);
select * from RangeTable PARTITION(part2);

--oracle 查看当前用户的分区表信息；
select * from  USER_PART_TABLES;