分区


alter table SIC_HI.SIC_HI_GUEST
add partition PART201409 values less than ('201410')
tablespace SIC_HI
pctfree 10
initrans 1
maxtrans 255
(
subpartition PART20140901 values ('20140901') tablespace SIC_HI,
subpartition PART20140902 values ('20140902') tablespace SIC_HI,
subpartition PART20140903 values ('20140903') tablespace SIC_HI,
subpartition PART20140904 values ('20140904') tablespace SIC_HI,
subpartition PART20140905 values ('20140905') tablespace SIC_HI,
subpartition PART20140906 values ('20140906') tablespace SIC_HI,
subpartition PART20140907 values ('20140907') tablespace SIC_HI,
subpartition PART20140908 values ('20140908') tablespace SIC_HI,
subpartition PART20140909 values ('20140909') tablespace SIC_HI,
subpartition PART20140910 values ('20140910') tablespace SIC_HI,
subpartition PART20140911 values ('20140911') tablespace SIC_HI,
subpartition PART20140912 values ('20140912') tablespace SIC_HI,
subpartition PART20140913 values ('20140913') tablespace SIC_HI,
subpartition PART20140914 values ('20140914') tablespace SIC_HI,
subpartition PART20140915 values ('20140915') tablespace SIC_HI,
subpartition PART20140916 values ('20140916') tablespace SIC_HI,
subpartition PART20140917 values ('20140917') tablespace SIC_HI,
subpartition PART20140918 values ('20140918') tablespace SIC_HI,
subpartition PART20140919 values ('20140919') tablespace SIC_HI,
subpartition PART20140920 values ('20140920') tablespace SIC_HI,
subpartition PART20140921 values ('20140921') tablespace SIC_HI,
subpartition PART20140922 values ('20140922') tablespace SIC_HI,
subpartition PART20140923 values ('20140923') tablespace SIC_HI,
subpartition PART20140924 values ('20140924') tablespace SIC_HI,
subpartition PART20140925 values ('20140925') tablespace SIC_HI,
subpartition PART20140926 values ('20140926') tablespace SIC_HI,
subpartition PART20140927 values ('20140927') tablespace SIC_HI,
subpartition PART20140928 values ('20140928') tablespace SIC_HI,
subpartition PART20140929 values ('20140929') tablespace SIC_HI,
subpartition PART20140930 values (DEFAULT) tablespace SIC_HI
);




alter table SIC_HI.SIC_HI_GUEST
add partition PART201410 values less than ('201411')
tablespace SIC_HI
pctfree 10
initrans 1
maxtrans 255
(
subpartition PART20141001 values ('20141001') tablespace SIC_HI,
subpartition PART20141002 values ('20141002') tablespace SIC_HI,
subpartition PART20141003 values ('20141003') tablespace SIC_HI,
subpartition PART20141004 values ('20141004') tablespace SIC_HI,
subpartition PART20141005 values ('20141005') tablespace SIC_HI,
subpartition PART20141006 values ('20141006') tablespace SIC_HI,
subpartition PART20141007 values ('20141007') tablespace SIC_HI,
subpartition PART20141008 values ('20141008') tablespace SIC_HI,
subpartition PART20141009 values ('20141009') tablespace SIC_HI,
subpartition PART20141010 values ('20141010') tablespace SIC_HI,
subpartition PART20141011 values ('20141011') tablespace SIC_HI,
subpartition PART20141012 values ('20141012') tablespace SIC_HI,
subpartition PART20141013 values ('20141013') tablespace SIC_HI,
subpartition PART20141014 values ('20141014') tablespace SIC_HI,
subpartition PART20141015 values ('20141015') tablespace SIC_HI,
subpartition PART20141016 values ('20141016') tablespace SIC_HI,
subpartition PART20141017 values ('20141017') tablespace SIC_HI,
subpartition PART20141018 values ('20141018') tablespace SIC_HI,
subpartition PART20141019 values ('20141019') tablespace SIC_HI,
subpartition PART20141020 values ('20141020') tablespace SIC_HI,
subpartition PART20141021 values ('20141021') tablespace SIC_HI,
subpartition PART20141022 values ('20141022') tablespace SIC_HI,
subpartition PART20141023 values ('20141023') tablespace SIC_HI,
subpartition PART20141024 values ('20141024') tablespace SIC_HI,
subpartition PART20141025 values ('20141025') tablespace SIC_HI,
subpartition PART20141026 values ('20141026') tablespace SIC_HI,
subpartition PART20141027 values ('20141027') tablespace SIC_HI,
subpartition PART20141028 values ('20141028') tablespace SIC_HI,
subpartition PART20141029 values ('20141029') tablespace SIC_HI,
subpartition PART20141030 values ('20141030') tablespace SIC_HI,
subpartition PART20141031 values (DEFAULT) tablespace SIC_HI
);



alter table SIC_HI.SIC_HI_GUEST
add partition PART201411 values less than ('201412')
tablespace SIC_HI
pctfree 10
initrans 1
maxtrans 255
(
subpartition PART20141101 values ('20141101') tablespace SIC_HI,
subpartition PART20141102 values ('20141102') tablespace SIC_HI,
subpartition PART20141103 values ('20141103') tablespace SIC_HI,
subpartition PART20141104 values ('20141104') tablespace SIC_HI,
subpartition PART20141105 values ('20141105') tablespace SIC_HI,
subpartition PART20141106 values ('20141106') tablespace SIC_HI,
subpartition PART20141107 values ('20141107') tablespace SIC_HI,
subpartition PART20141108 values ('20141108') tablespace SIC_HI,
subpartition PART20141109 values ('20141109') tablespace SIC_HI,
subpartition PART20141110 values ('20141110') tablespace SIC_HI,
subpartition PART20141111 values ('20141111') tablespace SIC_HI,
subpartition PART20141112 values ('20141112') tablespace SIC_HI,
subpartition PART20141113 values ('20141113') tablespace SIC_HI,
subpartition PART20141114 values ('20141114') tablespace SIC_HI,
subpartition PART20141115 values ('20141115') tablespace SIC_HI,
subpartition PART20141116 values ('20141116') tablespace SIC_HI,
subpartition PART20141117 values ('20141117') tablespace SIC_HI,
subpartition PART20141118 values ('20141118') tablespace SIC_HI,
subpartition PART20141119 values ('20141119') tablespace SIC_HI,
subpartition PART20141120 values ('20141120') tablespace SIC_HI,
subpartition PART20141121 values ('20141121') tablespace SIC_HI,
subpartition PART20141122 values ('20141122') tablespace SIC_HI,
subpartition PART20141123 values ('20141123') tablespace SIC_HI,
subpartition PART20141124 values ('20141124') tablespace SIC_HI,
subpartition PART20141125 values ('20141125') tablespace SIC_HI,
subpartition PART20141126 values ('20141126') tablespace SIC_HI,
subpartition PART20141127 values ('20141127') tablespace SIC_HI,
subpartition PART20141128 values ('20141128') tablespace SIC_HI,
subpartition PART20141129 values ('20141129') tablespace SIC_HI,
subpartition PART20141130 values (DEFAULT) tablespace SIC_HI
);




alter table SIC_HI.SIC_HI_GUEST
add partition PART201412 values less than ('201501')
tablespace SIC_HI
pctfree 10
initrans 1
maxtrans 255
(
subpartition PART20141201 values ('20141201') tablespace SIC_HI,
subpartition PART20141202 values ('20141202') tablespace SIC_HI,
subpartition PART20141203 values ('20141203') tablespace SIC_HI,
subpartition PART20141204 values ('20141204') tablespace SIC_HI,
subpartition PART20141205 values ('20141205') tablespace SIC_HI,
subpartition PART20141206 values ('20141206') tablespace SIC_HI,
subpartition PART20141207 values ('20141207') tablespace SIC_HI,
subpartition PART20141208 values ('20141208') tablespace SIC_HI,
subpartition PART20141209 values ('20141209') tablespace SIC_HI,
subpartition PART20141210 values ('20141210') tablespace SIC_HI,
subpartition PART20141211 values ('20141211') tablespace SIC_HI,
subpartition PART20141212 values ('20141212') tablespace SIC_HI,
subpartition PART20141213 values ('20141213') tablespace SIC_HI,
subpartition PART20141214 values ('20141214') tablespace SIC_HI,
subpartition PART20141215 values ('20141215') tablespace SIC_HI,
subpartition PART20141216 values ('20141216') tablespace SIC_HI,
subpartition PART20141217 values ('20141217') tablespace SIC_HI,
subpartition PART20141218 values ('20141218') tablespace SIC_HI,
subpartition PART20141219 values ('20141219') tablespace SIC_HI,
subpartition PART20141220 values ('20141220') tablespace SIC_HI,
subpartition PART20141221 values ('20141221') tablespace SIC_HI,
subpartition PART20141222 values ('20141222') tablespace SIC_HI,
subpartition PART20141223 values ('20141223') tablespace SIC_HI,
subpartition PART20141224 values ('20141224') tablespace SIC_HI,
subpartition PART20141225 values ('20141225') tablespace SIC_HI,
subpartition PART20141226 values ('20141226') tablespace SIC_HI,
subpartition PART20141227 values ('20141227') tablespace SIC_HI,
subpartition PART20141228 values ('20141228') tablespace SIC_HI,
subpartition PART20141229 values ('20141229') tablespace SIC_HI,
subpartition PART20141230 values ('20141230') tablespace SIC_HI,
subpartition PART20141231 values (DEFAULT) tablespace SIC_HI
);


alter table SIC_HI.SIC_HI_GUEST
add partition PART201501 values less than ('201502')
tablespace SIC_HI
pctfree 10
initrans 1
maxtrans 255
(
subpartition PART20150101 values ('20150101') tablespace SIC_HI,
subpartition PART20150102 values ('20150102') tablespace SIC_HI,
subpartition PART20150103 values ('20150103') tablespace SIC_HI,
subpartition PART20150104 values ('20150104') tablespace SIC_HI,
subpartition PART20150105 values ('20150105') tablespace SIC_HI,
subpartition PART20150106 values ('20150106') tablespace SIC_HI,
subpartition PART20150107 values ('20150107') tablespace SIC_HI,
subpartition PART20150108 values ('20150108') tablespace SIC_HI,
subpartition PART20150109 values ('20150109') tablespace SIC_HI,
subpartition PART20150110 values ('20150110') tablespace SIC_HI,
subpartition PART20150111 values ('20150111') tablespace SIC_HI,
subpartition PART20150112 values ('20150112') tablespace SIC_HI,
subpartition PART20150113 values ('20150113') tablespace SIC_HI,
subpartition PART20150114 values ('20150114') tablespace SIC_HI,
subpartition PART20150115 values ('20150115') tablespace SIC_HI,
subpartition PART20150116 values ('20150116') tablespace SIC_HI,
subpartition PART20150117 values ('20150117') tablespace SIC_HI,
subpartition PART20150118 values ('20150118') tablespace SIC_HI,
subpartition PART20150119 values ('20150119') tablespace SIC_HI,
subpartition PART20150120 values ('20150120') tablespace SIC_HI,
subpartition PART20150121 values ('20150121') tablespace SIC_HI,
subpartition PART20150122 values ('20150122') tablespace SIC_HI,
subpartition PART20150123 values ('20150123') tablespace SIC_HI,
subpartition PART20150124 values ('20150124') tablespace SIC_HI,
subpartition PART20150125 values ('20150125') tablespace SIC_HI,
subpartition PART20150126 values ('20150126') tablespace SIC_HI,
subpartition PART20150127 values ('20150127') tablespace SIC_HI,
subpartition PART20150128 values ('20150128') tablespace SIC_HI,
subpartition PART20150129 values ('20150129') tablespace SIC_HI,
subpartition PART20150130 values ('20150130') tablespace SIC_HI,
subpartition PART20150131 values (DEFAULT) tablespace SIC_HI
);



alter table SIC_HI.SIC_HI_GUEST
add partition PART201502 values less than ('201503')
tablespace SIC_HI
pctfree 10
initrans 1
maxtrans 255
(
subpartition PART20150201 values ('20150101') tablespace SIC_HI,
subpartition PART20150202 values ('20150102') tablespace SIC_HI,
subpartition PART20150203 values ('20150103') tablespace SIC_HI,
subpartition PART20150204 values ('20150104') tablespace SIC_HI,
subpartition PART20150205 values ('20150105') tablespace SIC_HI,
subpartition PART20150206 values ('20150106') tablespace SIC_HI,
subpartition PART20150207 values ('20150107') tablespace SIC_HI,
subpartition PART20150208 values ('20150108') tablespace SIC_HI,
subpartition PART20150209 values ('20150109') tablespace SIC_HI,
subpartition PART20150210 values ('20150110') tablespace SIC_HI,
subpartition PART20150211 values ('20150111') tablespace SIC_HI,
subpartition PART20150212 values ('20150112') tablespace SIC_HI,
subpartition PART20150213 values ('20150113') tablespace SIC_HI,
subpartition PART20150214 values ('20150114') tablespace SIC_HI,
subpartition PART20150215 values ('20150115') tablespace SIC_HI,
subpartition PART20150216 values ('20150116') tablespace SIC_HI,
subpartition PART20150217 values ('20150117') tablespace SIC_HI,
subpartition PART20150218 values ('20150118') tablespace SIC_HI,
subpartition PART20150219 values ('20150119') tablespace SIC_HI,
subpartition PART20150220 values ('20150120') tablespace SIC_HI,
subpartition PART20150221 values ('20150121') tablespace SIC_HI,
subpartition PART20150222 values ('20150122') tablespace SIC_HI,
subpartition PART20150223 values ('20150123') tablespace SIC_HI,
subpartition PART20150224 values ('20150124') tablespace SIC_HI,
subpartition PART20150225 values ('20150125') tablespace SIC_HI,
subpartition PART20150226 values ('20150126') tablespace SIC_HI,
subpartition PART20150227 values ('20150127') tablespace SIC_HI,
subpartition PART20150228 values (DEFAULT) tablespace SIC_HI
);



alter table SIC_HI.SIC_HI_GUEST
add partition PART201503 values less than ('201504')
tablespace SIC_HI
pctfree 10
initrans 1
maxtrans 255
(
subpartition PART20150301 values ('20150301') tablespace SIC_HI,
subpartition PART20150302 values ('20150302') tablespace SIC_HI,
subpartition PART20150303 values ('20150303') tablespace SIC_HI,
subpartition PART20150304 values ('20150304') tablespace SIC_HI,
subpartition PART20150305 values ('20150305') tablespace SIC_HI,
subpartition PART20150306 values ('20150306') tablespace SIC_HI,
subpartition PART20150307 values ('20150307') tablespace SIC_HI,
subpartition PART20150308 values ('20150308') tablespace SIC_HI,
subpartition PART20150309 values ('20150309') tablespace SIC_HI,
subpartition PART20150310 values ('20150310') tablespace SIC_HI,
subpartition PART20150311 values ('20150311') tablespace SIC_HI,
subpartition PART20150312 values ('20150312') tablespace SIC_HI,
subpartition PART20150313 values ('20150313') tablespace SIC_HI,
subpartition PART20150314 values ('20150314') tablespace SIC_HI,
subpartition PART20150315 values ('20150315') tablespace SIC_HI,
subpartition PART20150316 values ('20150316') tablespace SIC_HI,
subpartition PART20150317 values ('20150317') tablespace SIC_HI,
subpartition PART20150318 values ('20150318') tablespace SIC_HI,
subpartition PART20150319 values ('20150319') tablespace SIC_HI,
subpartition PART20150320 values ('20150320') tablespace SIC_HI,
subpartition PART20150321 values ('20150321') tablespace SIC_HI,
subpartition PART20150322 values ('20150322') tablespace SIC_HI,
subpartition PART20150323 values ('20150323') tablespace SIC_HI,
subpartition PART20150324 values ('20150324') tablespace SIC_HI,
subpartition PART20150325 values ('20150325') tablespace SIC_HI,
subpartition PART20150326 values ('20150326') tablespace SIC_HI,
subpartition PART20150327 values ('20150327') tablespace SIC_HI,
subpartition PART20150328 values ('20150328') tablespace SIC_HI,
subpartition PART20150329 values ('20150329') tablespace SIC_HI,
subpartition PART20150330 values ('20150330') tablespace SIC_HI,
subpartition PART20150331 values (DEFAULT) tablespace SIC_HI
);



alter table SIC_HI.SIC_HI_GUEST
add partition PART201504 values less than ('201505')
tablespace SIC_HI
pctfree 10
initrans 1
maxtrans 255
(
subpartition PART20150401 values ('20150401') tablespace SIC_HI,
subpartition PART20150402 values ('20150402') tablespace SIC_HI,
subpartition PART20150403 values ('20150403') tablespace SIC_HI,
subpartition PART20150404 values ('20150404') tablespace SIC_HI,
subpartition PART20150405 values ('20150405') tablespace SIC_HI,
subpartition PART20150406 values ('20150406') tablespace SIC_HI,
subpartition PART20150407 values ('20150407') tablespace SIC_HI,
subpartition PART20150408 values ('20150408') tablespace SIC_HI,
subpartition PART20150409 values ('20150409') tablespace SIC_HI,
subpartition PART20150410 values ('20150410') tablespace SIC_HI,
subpartition PART20150411 values ('20150411') tablespace SIC_HI,
subpartition PART20150412 values ('20150412') tablespace SIC_HI,
subpartition PART20150413 values ('20150413') tablespace SIC_HI,
subpartition PART20150414 values ('20150414') tablespace SIC_HI,
subpartition PART20150415 values ('20150415') tablespace SIC_HI,
subpartition PART20150416 values ('20150416') tablespace SIC_HI,
subpartition PART20150417 values ('20150417') tablespace SIC_HI,
subpartition PART20150418 values ('20150418') tablespace SIC_HI,
subpartition PART20150419 values ('20150419') tablespace SIC_HI,
subpartition PART20150420 values ('20150420') tablespace SIC_HI,
subpartition PART20150421 values ('20150421') tablespace SIC_HI,
subpartition PART20150422 values ('20150422') tablespace SIC_HI,
subpartition PART20150423 values ('20150423') tablespace SIC_HI,
subpartition PART20150424 values ('20150424') tablespace SIC_HI,
subpartition PART20150425 values ('20150425') tablespace SIC_HI,
subpartition PART20150426 values ('20150426') tablespace SIC_HI,
subpartition PART20150427 values ('20150427') tablespace SIC_HI,
subpartition PART20150428 values ('20150428') tablespace SIC_HI,
subpartition PART20150429 values ('20150429') tablespace SIC_HI,
subpartition PART20150430 values (DEFAULT) tablespace SIC_HI
);

转载于:https://www.cnblogs.com/myibm/p/5939551.html

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值