--創(chuàng)建表

create table sales1

(

sales_ID number,

product_id varchar2(5),

sale_date date not null

)

--創(chuàng)建分區(qū)

PARTITION by range (sale_date)

(

PARTITION p1 values less than (to_date('2013-04-01','yyyy-mm-dd')),

PARTITION p2 values less than (to_date('2013-07-01','yyyy-mm-dd')),

PARTITION p3 values less than (to_date('2013-10-01','yyyy-mm-dd')),

PARTITION p4 values less than (to_date('2014-01-01','yyyy-mm-dd')),

PARTITION p5 values less than (maxvalue)

);

--查詢語句

select * from sales1 partition(p5)

--查詢分區(qū)情況

select table_name,partition_name

from user_tab_partitions

where table_name=UPPER('sales1')

--間隔表分區(qū)

create table sales2

(

sales_ID number,

product_id varchar2(5),

sale_date date not null

)

PARTITION by range (sale_date)

interval(numtoyminterval(3,'month'))

(partition p1 values less than(to_date('2013-04-01','yyyy-mm-dd')));