Oracle表分區(qū)分為四種：范圍分區(qū)散列分區(qū)列表分區(qū)和復(fù)合分區(qū)

Oracle表分區(qū)分為四種：范圍分區(qū)，散列分區(qū)，列表分區(qū)和復(fù)合分區(qū)?：范圍分區(qū)就是根據(jù)數(shù)據(jù)庫表中某?字段的值的范圍來劃分分區(qū)，例如：Sql代碼createtablegraderecord(snovarchar2(10),snamevarchar2(20),dormitoryvarchar2(3),gradeint)partitionbyrange(grade)(partitionbujigevalueslessthan(60),--不及格partitionjigevalueslessthan(85),--及格partitionyouxiuvalueslessthan(maxvalue)--優(yōu)秀)插?實(shí)驗(yàn)數(shù)據(jù)：Sql代碼insertintograderecordvalues('511601','魁','229',92);insertintograderecordvalues('511602','凱','229',62);insertintograderecordvalues('511603','東','229',26);insertintograderecordvalues('511604','亮','228',77);insertintograderecordvalues('511605','敬','228',47);insertintograderecord(sno,sname,dormitory)values('511606','峰','228');insertintograderecordvalues('511607','明','240',90);insertintograderecordvalues('511608','楠','240',100);insertintograderecordvalues('511609','濤','240',67);insertintograderecordvalues('511610','博','240',75);insertintograderecordvalues('511611','錚','240',60);下?查詢?下全部數(shù)據(jù)，然后查詢各個(gè)分區(qū)數(shù)據(jù)，代碼?起寫：Java代碼select*fromgraderecord;select*fromgraderecordpartition(bujige);select*fromgraderecordpartition(jige);select*fromgraderecordpartition(youxiu);?：散列分區(qū)即Hash分區(qū)，實(shí)現(xiàn)類似負(fù)載均衡散列分區(qū)是根據(jù)字段的hash值進(jìn)?均勻分布，盡可能的實(shí)現(xiàn)各分區(qū)所散列的數(shù)據(jù)相等。還是剛才那個(gè)表，只不過把范圍分區(qū)改換為散列分區(qū)，語法如下（刪除表之后重建）：snamevarchar2(20),dormitoryvarchar2(3),gradeint)partitionbyhash(sno)(partitionp1,partitionp2,partitionp3);插?實(shí)驗(yàn)數(shù)據(jù)，與范圍分區(qū)實(shí)驗(yàn)插?的數(shù)據(jù)相同。然后查詢分區(qū)數(shù)據(jù)：Sql代碼select*fromgraderecordpartition(p1);select*fromgraderecordpartition(p2);select*fromgraderecordpartition(p3);說明：散列分區(qū)即為哈希分區(qū)，Oracle采?哈希碼技術(shù)分區(qū)，具體分區(qū)如何由Oracle說的算，也可能我下?次搜索就不是這個(gè)數(shù)據(jù)了。三：列表分區(qū)列表分區(qū)明確指定了根據(jù)某字段的某個(gè)具體值進(jìn)?分區(qū)，?不是像范圍分區(qū)那樣根據(jù)字段的值范圍來劃分的。Sql代碼createtablegraderecord(snovarchar2(10),snamevarchar2(20),dormitoryvarchar2(3),gradeint)partitionbylist(dormitory)(partitiond229values('229'),partitiond228values('228'),partitiond240values('240'))以上根據(jù)宿舍來進(jìn)?列表分區(qū)，插?與范圍分區(qū)實(shí)驗(yàn)相同的數(shù)據(jù)，做查詢?nèi)缦拢篠ql代碼select*fromgraderecordpartition(d229);select*fromgraderecordpartition(d228);select*fromgraderecordpartition(d240);四：復(fù)合分區(qū)（范圍-散列分區(qū)，范圍-列表分區(qū)）?先講范圍-散列分區(qū)。先聲明?下：列表分區(qū)不?持多列，但是范圍分區(qū)和哈希分區(qū)?持多列。代碼如下：snamevarchar2(20),dormitoryvarchar2(3),gradeint)partitionbyrange(grade)subpartitionbyhash(sno,sname)(partitionp1valueslessthan(75)(subpartitionsp1,subpartitionsp2),partitionp2valueslessthan(maxvalue)(subpartitionsp3,subpartitionsp4));**以grade劃分范圍，然后以sno和sname劃分散列分區(qū)，當(dāng)數(shù)據(jù)量?的時(shí)候散列分區(qū)則趨于“平均”。**插?數(shù)據(jù)：Sql代碼insertintograderecordvalues('511601','魁','229',92);insertintograderecordvalues('511602','凱','229',62);insertintograderecordvalues('511603','東','229',26);insertintograderecordvalues('511604','亮','228',77);insertintograderecordvalues('511605','敬','228',47);insertintograderecord(sno,sname,dormitory)values('511606','峰','228');insertintograderecordvalues('511607','明','240',90);insertintograderecordvalues('511608','楠','240',100);insertintograderecordvalues('511609','濤','240',67);insertintograderecordvalues('511610','博','240',75);insertintograderecordvalues('511611','錚','240',60);insertintograderecordvalues('511612','貍','244',72);insertintograderecordvalues('511613','杰','244',88);insertintograderecordvalues('511614','萎','244',19);insertintograderecordvalues('511615','猥','244',65);insertintograderecordvalues('511616','丹','244',59);insertintograderecordvalues('511617','靳','244',95);查詢?nèi)缦拢篠ql代碼select*fromgraderecordpartition(p1);select*fromgraderecordpartition(p2);select*fromgraderecordsubpartition(sp1);select*fromgraderecordsubpartition(sp2);select*fromgraderecordsubpartition(sp3);select*fromgraderecordsubpartition(sp4);說明：當(dāng)數(shù)據(jù)量越來越?時(shí)，哈希分區(qū)的分區(qū)表中數(shù)據(jù)越來越趨于平衡。下?講范圍-列表分區(qū)范圍-列表分區(qū)有兩種創(chuàng)??式，先說說沒有模板的創(chuàng)建?式，這個(gè)表我要重建：ACCT_MONTHVARCHAR2(6),--帳期格式：年?YYYYMMAREA_NOVARCHAR2(10),--地域號(hào)碼DAY_IDVARCHAR2(2),--本?中的第?天格式DDSUBSCRBIDVARCHAR2(20),--?戶標(biāo)識(shí)SVCNUMVARCHAR2(30)--?機(jī)號(hào)碼)partitionbyrange(ACCT_MONTH,AREA_NO)subpartitionbylist(DAY_ID)(partitionp1valueslessthan('200705','012')(subpartitionshangxun1values('01','02','03','04','05','06','07','08','09','10'),subpartitionzhongxun1values('11','12','13','14','15','16','17','18','19','20'),subpartitionxiaxun1values('21','22','23','24','25','26','27','28','29','30','31')),partitionp2valueslessthan('200709','014')(subpartitionshangxun2values('01','02','03','04','05','06','07','08','09','10'),subpartitionzhongxun2values('11','12','13','14','15','16','17','18','19','20'),subpartitionxiaxun2values('21','22','23','24','25','26','27','28','29','30','31')),partitionp3valueslessthan('200801','016')(subpartitionshangxun3values('01','02','03','04','05','06','07','08','09','10'),subpartitionzhongxun3values('11','12','13','14','15','16','17','18','19','20'),subpartitionxiaxun3values('21','22','23','24','25','26','27','28','29','30','31')))插?實(shí)驗(yàn)數(shù)據(jù)：Sql代碼insertintoMobileMessagevalues('200701','010','04','ghk001','138********');insertintoMobileMessagevalues('200702','015','12','myx001','136********');insertintoMobileMessagevalues('200703','015','24','hjd001','133********');insertintoMobileMessagevalues('200704','010','04','ghk001','138********');insertintoMobileMessagevalues('200705','010','04','ghk001','138********');insertintoMobileMessagevalues('200705','011','18','sxl001','132********');insertintoMobileMessagevalues('200706','011','21','sxl001','132********');insertintoMobileMessagevalues('200706','012','11','tgg001','138********');insertintoMobileMessagevalues('200707','010','04','ghk001','138********');insertintoMobileMessagevalues('200708','012','24','tgg001','138********');insertintoMobileMessagevalues('200709','014','29','zjj001','131********');insertintoMobileMessagevalues('200710','014','29','zjj001','131********');insertintoMobileMessagevalues('200711','014','29','zjj001','131********');insertintoMobileMessagevalues('200711','013','30','wgc001','134********');insertintoMobileMessagevalues('200712','013','30','wgc001','134********');insertintoMobileMessagevalues('200712','010','30','ghk001','138********');insertintoMobileMessagevalues('200801','015','22','myx001','136********');select*fromMobileMessage;說明：范圍分區(qū)range(A,B)的分區(qū)法則，范圍分區(qū)都是valueslessthan(A,B)的，通常情況下以A為準(zhǔn)，如果?于A的不?考慮B，直接插進(jìn)去，如果等于A那么考慮B，要是滿?B的話也插進(jìn)去。另?種范圍-列表分區(qū)，包含模板的（?較繁瑣，但是更加精確，處理海量存儲(chǔ)數(shù)據(jù)?分必要）：Sql代碼createtableMobileMessage(ACCT_MONTHVARCHAR2(6),--帳期格式：年?YYYYMMAREA_NOVARCHAR2(10),--地域號(hào)碼DAY_IDVARCHAR2(2),--本?中的第?天格式DDSUBSCRBIDVARCHAR2(20),--?戶標(biāo)識(shí)SVCNUMVARCHAR2(30)--?機(jī)號(hào)碼)partitionbyrange(ACCT_MONTH,AREA_NO)subpartitionbylist(DAY_ID)subpartitiontemplate(subpartitionsub1values('01'),subpartitionsub2values('02'),subpartitionsub3values('03'),subpartitionsub4values('04'),subpartitionsub5values('05'),subpartitionsub6values('06'),subpartitionsub7values('07'),subpartitionsub8values('08'),subpartitionsub9values('09'),subpartitionsub10values('10'),subpartitionsub11values('11'),subpartitionsub12values('12'),subpartitionsub13values('13'),subpartitionsub14values('14'),subpartitionsub15values('15'),subpartitionsub16values('16'),subpartitionsub17values('17'),subpartitionsub18values('18'),subpartitionsub19values('19'),subpartitionsub20values('20'),subpartitionsub21values('21'),subpartitionsub22values('22'),subpartitionsub23values('23'),subpartitionsub24values('24'),subpartitionsub25values('25'),subpartitionsub26values('26'),subpartitionsub27values('27'),subpartitionsub28values('28'),subpartitionsub29values('29'),subpartitionsub30values('30'),subpartitionsub31values('31'))(partitionp_0701_010valueslessthan('200701','011'),partitionp_0701_011valueslessthan('200701','012'),partitionp_0701_012valueslessthan('200701','013'),partitionp_0701_013valueslessthan('200701','014'),partitionp_0701_014valueslessthan('200701','015'),partitionp_0701_015valueslessthan('200701','016'),partitionp_0702_010valueslessthan('200702','011'),partitionp_0702_011valueslessthan('200702','012'),partitionp_0702_012valueslessthan('200702','013'),partitionp_0702_013valueslessthan('200702','014'),partitionp_0702_014valueslessthan('200702','015'),partitionp_0702_015valueslessthan('200702','016'),partitionp_0703_010valueslessthan('200703','011'),partitionp_0703_011valueslessthan('200703','012'),partitionp_0703_012valueslessthan('200703','013'),partitionp_0703_013valueslessthan('200703','014'),partitionp_0703_014valueslessthan('200703','015'),partitionp_0703_015valueslessthan('200703','016'),partitionp_0704_010valueslessthan('200704','011'),partitionp_0704_011valueslessthan('200704','012'),partitionp_0704_012valueslessthan('200704','013'),partitionp_0704_013valueslessthan('200704','014'),partitionp_0704_014valueslessthan('200704','015'),partitionp_0704_015valueslessthan('200704','016'),partitionp_0705_010valueslessthan('200705','011'),partitionp_0705_011valueslessthan('200705','012'),partitionp_0705_012valueslessthan('200705','013'),partitionp_0705_013valueslessthan('200705','014'),partitionp_0705_014valueslessthan('200705','015'),partitionp_0705_015valueslessthan('200705','016'),partitionp_0706_010valueslessthan('200706','011'),partitionp_0706_011valueslessthan('200706','012'),partitionp_0706_012valueslessthan('200706','013'),partitionp_0706_013valueslessthan('200706','014'),partitionp_0706_014valueslessthan('200706','015'),partitionp_0706_015valueslessthan('200706','016'),partitionp_0707_010valueslessthan('200707','011'),partitionp_0707_011valueslessthan('200707','012'),partitionp_0707_012valueslessthan('200707','013'),partitionp_0707_013valueslessthan('200707','014'),partitionp_0707_014valueslessthan('200707','015'),partitionp_0707_015valueslessthan('200707','016'),partitionp_0708_010valueslessthan('200708','011'),partitionp_0708_011valueslessthan('200708','012'),partitionp_0708_012valueslessthan('200708','013'),partitionp_0708_013valueslessthan('200708','014'),partitionp_0708_014valueslessthan('200708','015'),partitionp_0708_015valueslessthan('200708','016'),partitionp_0709_010valueslessthan('200709','011'),partitionp_0709_011valueslessthan('200709','012'),partitionp_0709_012valueslessthan('200709','013'),partitionp_0709_013valueslessthan('200709','014'),partitionp_0709_014valueslessthan('200709','015'),partitionp_0709_015valueslessthan('200709','016'),partitionp_0710_010valueslessthan('200710','011'),partitionp_0710_011valueslessthan('200710','012'),partitionp_0710_012valueslessthan('200710','013'),partitionp_0710_013valueslessthan('200710','014'),partitionp_0710_014valueslessthan('200710','015'),partitionp_0710_015valueslessthan('200710','016'),partitionp_0711_010valueslessthan('200711','011'),partitionp_0711_011valueslessthan('200711','012'),partitionp_0711_012valueslessthan('200711','013'),partitionp_0711_013valueslessthan('200711','014'),partitionp_0711_014valueslessthan('200711','015'),partitionp_0711_015valueslessthan('200711','016'),partitionp_0712_010valueslessthan('200712','011'),partitionp_0712_011valueslessthan('200712','012'),partitionp_0712_012valueslessthan('200712','013'),partitionp_0712_013valueslessthan('200712','014'),partitionp_0712_014valueslessthan('200712','015'),partitionp_0712_015valueslessthan('200712','016'),partitionp_0801_010valueslessthan('200801','011'),partitionp_0801_011valueslessthan('200801','012'),partitionp_0801_012valueslessthan('200801','013'),partitionp_0801_013valueslessthan('200801','014'),partitionp_0801_014valueslessthan('200801','015'),partitionp_0801_015valueslessthan('200801','016'),partitionp_othervalueslessthan(maxvalue,maxvalue));這個(gè)是帶有模板?分區(qū)的，模板?分區(qū)詳細(xì)到?中的天。這種分區(qū)模式只要建?了分區(qū)就會(huì)?動(dòng)創(chuàng)建?分區(qū)的。插?上?不帶模板分區(qū)實(shí)驗(yàn)相同的數(shù)據(jù)，隨機(jī)查詢分區(qū)數(shù)據(jù)：查詢分區(qū)p_0701_010的數(shù)據(jù)：Sql代碼select*fromMobileMessagepartition(p_0701_010);查詢?分區(qū)p_0701_010_sub4的數(shù)據(jù)：Sql代碼select*fromMobileMessagesubpartition(p_0701_010_sub4);查詢分區(qū)p_0706_011的數(shù)據(jù)：Sql代碼select*fromMobileMessagepartition(p_0706_011);查詢結(jié)果如下：查詢?分區(qū)p_0706_011_sub21的數(shù)據(jù)：Sql代碼select*fromMobileMessagesubpartition(p_0706_011_sub21);查詢結(jié)果如下：下?講講分區(qū)的維護(hù)操作：(1)分裂分區(qū)，以第?個(gè)范圍分區(qū)為例：Sql代碼altertablegraderecordsplitpartitionjigeat(75)into(partitionkeyi,partitionlianghao);把分區(qū)及格分裂為兩個(gè)分區(qū)：可以和良好。(2)合并分區(qū)，以第?個(gè)范圍分區(qū)為例：Sql代碼altertablegraderecordmergepartitionskeyi,lianghaointopartitionjige;把可以和良好兩個(gè)分區(qū)合并為及格。(3)添加分區(qū)，由于在范圍分區(qū)上添加分區(qū)要求添加的分區(qū)范圍?于原有分區(qū)最?值，但原有分區(qū)最?值已經(jīng)為maxvalue，故本處以第?個(gè)散列分區(qū)為例：Sql代碼altertablegraderecordaddpartitionp4;給散列分區(qū)例??增加了?個(gè)分區(qū)p4。(4)刪除分區(qū)，語法：Sql代碼altertabletable_namedroppartitionpartition_name;(5)截?cái)喾謪^(qū)，清空分區(qū)中的數(shù)據(jù)Sql代碼altertabletable_nametruncatepartitionpartition_name;說明：對待分區(qū)的操作同樣可以對待?分區(qū)，效果?樣。刪除?個(gè)分區(qū)會(huì)同時(shí)刪除其下的?分區(qū)。合并多個(gè)分區(qū)也會(huì)把他們的?分區(qū)?動(dòng)合并。分裂分區(qū)時(shí)注意分裂點(diǎn)。另外不帶模板?分區(qū)和帶有模板?分區(qū)的分區(qū)表操作的區(qū)別：帶有?分區(qū)模板的分區(qū)表在添加分區(qū)時(shí)候?動(dòng)添加?分區(qū)，不帶模板?分區(qū)的分區(qū)表沒有這個(gè)功能；帶有?分區(qū)模板的分區(qū)表在更改分區(qū)時(shí)只需更改分區(qū)，不帶模板?分區(qū)的分區(qū)表在更改分區(qū)時(shí)?定注意連同?分區(qū)?起更改。Range分區(qū)代碼+Range&&List分區(qū)代碼（utf-8,親測可?）--Oracle建議如果單個(gè)表超過2G就最好對其進(jìn)?分區(qū)CREATETABLEgraderecord(CREATETABLEgraderecord(snoVARCHAR2(10),snameVARCHAR2(20),dormitoryVARCHAR2(3),gradeINT)PARTITIONBYRANGE(grade)(PARTITIONfailVALUESLESSTHAN(60),PARTITIONpassVALUESLESSTHAN(85),PARTITIONgoodVALUESLESSTHAN(100));INSERTINTOgraderecordVALUES('511601','魁','229',92);INSERTINTOgraderecordVALUES('511602','凱','229',62);INSERTINTOgraderecordVALUES('511603','東','229',26);INSERTINTOgraderecordVALUES('511604','亮','228',77);INSERTINTOgraderecordVALUES('511605','敬','228',47);INSERTINTOgraderecordVALUES('511606','峰','228',98);INSERTINTOgraderecordVALUES('511607','明','240',90);--INSERTINTOgraderecordVALUES('511607','明','240');--該數(shù)據(jù)插?不進(jìn)去，因?yàn)閿?shù)據(jù)字段不夠INSERTINTOgraderecordVALUES('511608','楠','240',99);--INSERTINTOgraderecordVALUES('511608','楠','240',100);--該條數(shù)據(jù)插?不進(jìn)去,因?yàn)?00超過了分區(qū)的數(shù)據(jù)的范圍INSERTINTOgraderecordVALUES('511609','濤','240',67);INSERTINTOgraderecordVALUES('511610','博','240',75);INSERTINTOgraderecordVALUES('511611','錚','240',60);insertintograderecord(sno,sname,dormitory,grade)values('5116012','哈','240',2);select*fromgraderecord;SELECT*FROMgraderecordPARTITION(fail);SELECT*FROMgraderecordPARTITION(pass);SELECT*FROMgraderecordPARTITION(good);--Range_List分區(qū)?式，?般是在range基礎(chǔ)上做的?級(jí)分區(qū)較多--包含模板的（?較繁瑣，但是更加精確，處理海量存儲(chǔ)數(shù)據(jù)?分必要）createtableMobileMessage(ACCT_MONTHVARCHAR2(6),--帳期格式：年?YYYYMMAREA_NOVARCHAR2(10),--地域號(hào)碼DAY_IDVARCHAR2(2),--本?中的第?天格式DDSUBSCRBIDVARCHAR2(20),--?戶標(biāo)識(shí)SVCNUMVARCHAR2(30)--?機(jī)號(hào)碼)partitionbyrange(ACCT_MONTH,AREA_NO)subpartitionbylist(DAY_ID)subpartitiontemplate(subpartitionsub1values('01'),subpartitionsub2values('02'),subpartitionsub3values('03'),subpartitionsub4values('04'),subpartitionsub5values('05'),subpartitionsub6values('06'),subpartitionsub7values('07'),subpartitionsub8values('08'),subpartitionsub9values('09'),subpartitionsub10values('10'),subpartitionsub11values('11'),subpartitionsub12values('12'),subpartitionsub13values('13'),subpartitionsub14values('14'),subpartitionsub15values('15'),subpartitionsub16values('16'),subpartitionsub17values('17'),subpartitionsub18values('18'),subpartitionsub19values('19'),subpartitionsub20values('20'),subpartitionsub21values('21'),subpartitionsub22values('22'),subpartitionsub23values('23'),subpartitionsub24values('24'),subpartitionsub25values('25'),subpartitionsub26values('26'),subpartitionsub27values('27'),subpartitionsub28values('28'),subpartitionsub29values('29'),subpartitionsub30values('30'),subpartitionsub31values('31'))((partitionp_0701_010valueslessthan('200701','011'),partitionp_0701_011valueslessthan('200701','012'),partitionp_0701_012valueslessthan('200701','013'),partitionp_0701_013valueslessthan('200701','014'),partitionp_0701_014valueslessthan('200701','015'),partitionp_0701_015valueslessthan('200701','016'),partitionp_0702_010valueslessthan('200702','011'),partitionp_0702_011valueslessthan('200702','012'),partitionp_0702_012valueslessthan('200702','013'),partitionp_0702_013valueslessthan('200702','014'),partitionp_0702_014valueslessthan('200702','015'),partitionp_0702_015valueslessthan('200702','016'),partitionp_0703_010valueslessthan('200703','011'),partitionp_0703_011valueslessthan('200703','012'),partitionp_0703_012valueslessthan('200703','013'),partitionp_0703_013valueslessthan('200703','014'),partitionp_0703_014valueslessthan('200703','015'),partitionp_0703_015valueslessthan('200703','016'),partitionp_0704_010valueslessthan('200704','011'),partitionp_0704_011valueslessthan('200704','012'),partitionp_0704_012valueslessthan('200704','013'),partitionp_0704_013valueslessthan('200704','014'),partitionp_0704_014valueslessthan('200704','015'),partitionp_0704_015valueslessthan('200704','016'),partitionp_0705_010valueslessthan('200705','011'),partitionp_0705_011valueslessthan('200705','012'),partitionp_0705_012valueslessthan('200705','013'),partitionp_0705_013valueslessthan('200705','014'),partitionp_0705_014valueslessthan('200705','015'),partitionp_0705_015valueslessthan('200705','016'),partitionp_0706_010valueslessthan('200706','011'),partitionp_0706_011valueslessthan('200706','012'),partitionp_0706_012valueslessthan('200706','013'),partitionp_0706_013valueslessthan('200706','014'),partitionp_0706_014valueslessthan('200706','015'),partitionp_0706_015valueslessthan('200706','016'),partitionp_0707_010valueslessthan('200707','011'),partitionp_0707_011valueslessthan('200707','012'),partitionp_0707_012valueslessthan('200707','013'),partitionp_0707_013valueslessthan('200707','014'),partitionp_0707_014valueslessthan('200707','015'),partitionp_0707_015valueslessthan('200707','016'),partitionp_0708_010valueslessthan('200708','011'),partitionp_0708_011valueslessthan('200708','012'),partitionp_0708_012valueslessthan('200708','013'),partitionp_0708_013valueslessthan('200708','014'),partitionp_0708_014valueslessthan('200708','015'),partitionp_0708_015valueslessthan('200708','016'),partitionp_0709_010valueslessthan('200709','011'),partitionp_0709_011valueslessthan('200709','012'),partitionp_0709_012valueslessthan('200709','013'),partitionp_0709_013valueslessthan('200709','014'),partitionp_0709_014valueslessthan('200709','015'),partitionp_0709_015valueslessthan('200709','016'),partitionp_0710_010valueslessthan('200710','011'),partitionp_0710_011valueslessthan('200710','012'),partitionp_0710_012valueslessthan('200710','013'),partitionp_0710_013valueslessthan('200710','014'),partitionp_0710_014valueslessthan('200710','015'),partitionp_0710_015valueslessthan('200710','016'),partitionp_0711_010valueslessthan('200711','011'),partitionp_0711_011valueslessthan('200711','012'),partitionp_0711_012valueslessthan('200711','013'),partitionp_0711_013valueslessthan('200711','014'),partitionp_0711_014valueslessthan('200711','015'),partitionp_0711_014valueslessthan('200711','015'),partitionp_0711_015valueslessthan('200711','016'),partitionp_0712_010valueslessthan('200712','011'),partitionp_0712_011valueslessthan('200712','012'),partitionp_0712_012valueslessthan('200712','013'),partitionp_0712_013valueslessthan('200712','014'),partitionp_0712_014valueslessthan('200712','015'),partitionp_0712_015valueslessthan('200712','016'),partitionp_0801_010valueslessthan('200801','011'),partitionp_0801_011valueslessthan('200801','012'),partitionp_0801_012valueslessthan('200801','013'),partitionp_0801_013valueslessthan('200801','014'),partitionp_0801_014valueslessthan('200801','015'),partitionp_0801_015values