表分区

--范围分区
--建表
create table orders
(
order_id number(12),
order_date date not null,
order_total number(8,2)
) 
partition by RANGE(order_date)
(
partition p1 VALUES less than (to_date('2015-01-01','yyyy-mm-dd')),
partition p2 VALUES less than (maxvalue)
)
INSERT INTO orders VALUES(1,SYSDATE,200)

SELECT * from orders partition(p1)

SELECT table_name,partition_name 
FROM user_tab_partitions 
WHERE table_name=UPPER('orders');

 

posted @ 2017-09-18 12:16  呵呵哒12138  阅读(87)  评论(0编辑  收藏  举报