oracle分区表&索引(例子)

------------------------首先创建分区表-------------------------------------------------

 create table store_sales
 (store_id number(6),invoice_number number,
 time_id date,invoice_sale_amt number(10,2))
 partition by range(time_id) subpartition by hash(invoice_number)
 (partition sales_q1_2003
 values less than (to_date('2003-01-05','YYYY-MM-DD')),
 partition sales_q2_2003
 values less than(to_date('2003-01-10','YYYY-MM-DD')),
 partition sales_q3_2003
 values less than (to_date('2003-01-15','YYYY-MM-DD'))
 (subpartition ch_c,subpartition ch_i,
 subpartition ch_p,subpartition ch_s,subpartition ch_t),
 partition sales_q4_2003
 values less than (to_date('2004-01-03','YYYY-MM-DD'))
 SUBPARTITIONS 8,
 partition sales_overflow
 values less than (maxvalue)subpartitions 4);

 

----------------------------------接着创建索引-----------------------------------

create index sales_ix on store_sales(time_id,store_id)
storage(initial 1m maxextents unlimited) local
(partition q1_2003,
partition q2_2003,
partition q3_2003
(subpartition pq3200301,subpartition pq3200302,
subpartition pq3200303,subpartition pq3200304,
subpartition pq3200305),
partition q4_2003
(subpartition pq4200301 tablespace system,
subpartition pq4200302 tablespace system,
subpartition pq4200303 tablespace system,
subpartition pq4200304 tablespace system,
subpartition pq4200305 tablespace system,
subpartition pq4200306 tablespace system,
subpartition pq4200307 tablespace system,
subpartition pq4200308 tablespace system),
partition sales_overflow
(subpartition pqoflw01 tablespace system,
subpartition pqoflw02 tablespace system,
subpartition pqoflw03 tablespace system,
subpartition pqoflw04 tablespace system))
/

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值