4个分区思想 3

--历史表的分区创建

partition by range (part_min)

(

  partition part_1 values less than ('15')

    tablespace tbs_lbi_dm

    pctfree 10

    initrans 1

    maxtrans 255

    storage

    (

      initial 8m

      next 1m

      minextents 1

      maxextents unlimited

    ),

  partition part_2 values less than ('30')

    tablespace tbs_lbi_dm

    pctfree 10

    initrans 1

    maxtrans 255

    storage

    (

      initial 8m

      next 1m

      minextents 1

      maxextents unlimited

    ),

  partition part_3 values less than ('45')

    tablespace tbs_lbi_dm

    pctfree 10

    initrans 1

    maxtrans 255

    storage

    (

      initial 8m

      next 1m

      minextents 1

      maxextents unlimited

    ),

  partition part_4 values less than ('60')

    tablespace tbs_lbi_dm

    pctfree 10

    initrans 1

    maxtrans 255

    storage

    (

      initial 8m

      next 1m

      minextents 1

      maxextents unlimited

    )

);