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
)
)
Oracle表中分区及子分区
最新推荐文章于 2024-01-09 17:53:12 发布