-- 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;