oracle分区
范围分区
例子:按表中年份字段来分区
create table sales2(invoice_no number,sale_year number,sale_month number,sale_day number)
partition by range (sale_year)
(
partition sp1 values less than (2012) tablespace salespace,
partition sp2 values less than (2013),
partition sp3 values less than (2014)
)
查询分区情况
select table_name,partition_name from user_tab_partitions where table_name=upper('表名(sales)')
查询数据
select * from sales2 partition (区名)