oracle分区

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 (区名)