oracle分区表学习与应用

时间:2011-09-24 09:26:24
【文件属性】:

文件名称:oracle分区表学习与应用

文件大小:25KB

文件格式:DOC

更新时间:2011-09-24 09:26:24

分区表

oracle 分区表学习及应用示例Create table(创建分区表)   create table BILL_MONTHFEE_ZERO   (   SERV_ID       NUMBER(20) not null,   BILLING_CYCLE_MONTH NUMBER(6) not null,   DATE_TYPE      NUMBER(1),   ACC_NBR       VARCHAR2(80)   )   partition by range (BILLING_CYCLE_MONTH)   (partition p_200407 values less than (200407)   tablespace TS_ZIKEN   storage(initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0),   partition p_200408 values less than (200408)   tablespace TS_ZIKEN   storage(initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0))   ;   create index idx_bill_monthfee_zero_idx01 on bill_monthfee_zero(billing_cycle_month)   tablespace TS_ZIKEN_idx   storage(initial 100k next 100k minextents 1 maxextents unlimited pctincrease 0) nologging;   grant all on bill_monthfee_zero to dxsq_dev;


网友评论