Oracle表中分区及子分区

partition by range (STAT_DATE)
subpartition by range (ORG_NO)
(
  partition DATA20170620 values less than ('20170621')
    tablespace DAY20SPACE
    pctfree 10
    initrans 1
    maxtrans 255
  (
    subpartition DATA20170620_PART22101 values less than ('22102') tablespace DAY20SPACE,
    subpartition DATA20170620_PART22401 values less than ('22402') tablespace DAY20SPACE,
    subpartition DATA20170620_PART22402 values less than ('22403') tablespace DAY20SPACE,
    subpartition DATA20170620_PART22403 values less than ('22404') tablespace DAY20SPACE,
    subpartition DATA20170620_PART22404 values less than ('22405') tablespace DAY20SPACE,
    subpartition DATA20170620_PART22405 values less than ('22406') tablespace DAY20SPACE,
    subpartition DATA20170620_PART22406 values less than ('22407') tablespace DAY20SPACE,
    subpartition DATA20170620_PART22407 values less than ('22408') tablespace DAY20SPACE,
    subpartition DATA20170620_PART22408 values less than ('22409') tablespace DAY20SPACE,
    subpartition DATA20170620_PART22409 values less than ('22410') tablespace DAY20SPACE
  )
  )