BMPS_HIS_RECEIVE_GPSINFO
(
SEQUENCE NUMBER(32) not null,
MCUID NUMBER(10) not null,
DEVICENO VARCHAR2(20) not null,
SIMNUM VARCHAR2(16),
BLUETOOTHID VARCHAR2(12),
CMDTYPE NUMBER(3) not null,
CMDSTATUS NUMBER(3) not null,
VEHICLESTATUS VARCHAR2(20),
LONGITUDE NUMBER(10) not null,
LATITUDE NUMBER(10) not null,
ANGLE NUMBER(5) not null,
VELOCITY NUMBER(5) not null,
FLAG NUMBER(3) not null,
LOCATESTATE NUMBER(3) not null,
POSITIONTIME DATE not null,
RECEIVETIME DATE not null,
SPEEDOMETER NUMBER(10),
RESERVE NUMBER(5)
)这个表已经存储了几千W的数据了，每秒产生100多条数据，提取的时候大部分是POSITIONTIME按天提取，所以打算POSITIONTIME进行天分区，不知各位有什么好的解决办法？SQL如何写？365次？
分不多了..抱歉啊....
(
SEQUENCE NUMBER(32) not null,
MCUID NUMBER(10) not null,
DEVICENO VARCHAR2(20) not null,
SIMNUM VARCHAR2(16),
BLUETOOTHID VARCHAR2(12),
CMDTYPE NUMBER(3) not null,
CMDSTATUS NUMBER(3) not null,
VEHICLESTATUS VARCHAR2(20),
LONGITUDE NUMBER(10) not null,
LATITUDE NUMBER(10) not null,
ANGLE NUMBER(5) not null,
VELOCITY NUMBER(5) not null,
FLAG NUMBER(3) not null,
LOCATESTATE NUMBER(3) not null,
POSITIONTIME DATE not null,
RECEIVETIME DATE not null,
SPEEDOMETER NUMBER(10),
RESERVE NUMBER(5)
)这个表已经存储了几千W的数据了，每秒产生100多条数据，提取的时候大部分是POSITIONTIME按天提取，所以打算POSITIONTIME进行天分区，不知各位有什么好的解决办法？SQL如何写？365次？
分不多了..抱歉啊....
PARTITION part_ 2 VALUES LESS THAN (TO_DATE(' 2011-1-2 ','YYYY-MM-DD')),
PARTITION part_ 3 VALUES LESS THAN (TO_DATE(' 2011-1-3 ','YYYY-MM-DD')),
PARTITION part_ 4 VALUES LESS THAN (TO_DATE(' 2011-1-4 ','YYYY-MM-DD')),
PARTITION part_ 5 VALUES LESS THAN (TO_DATE(' 2011-1-5 ','YYYY-MM-DD')),
PARTITION part_ 6 VALUES LESS THAN (TO_DATE(' 2011-1-6 ','YYYY-MM-DD')),
-- 然后copy 到 txt 文件里，将 tab 值替换一下！
(
SEQ NUMBER(32) not null,
MCUID NUMBER(10) not null,
DEVICENO VARCHAR2(20) not null,
SIMNUM VARCHAR2(16),
BLUETOOTHID VARCHAR2(12),
CMDTYPE NUMBER(3) not null,
CMDSTATUS NUMBER(3) not null,
VEHICLESTATUS VARCHAR2(20),
LONGITUDE NUMBER(10) not null,
LATITUDE NUMBER(10) not null,
ANGLE NUMBER(5) not null,
VELOCITY NUMBER(5) not null,
FLAG NUMBER(3) not null,
LOCATESTATE NUMBER(3) not null,
POSITIONTIME DATE not null,
RECEIVETIME DATE not null,
SPEEDOMETER NUMBER(10),
RESERVE NUMBER(5)
)
PARTITION BY RANGE(POSITIONTIME)
(
PARTITION part_1 VALUES LESS THAN (TO_DATE('2011-1-1','YYYY-MM-DD')),
PARTITION part_2 VALUES LESS THAN (TO_DATE('2011-1-2','YYYY-MM-DD')),
PARTITION part_3 VALUES LESS THAN (TO_DATE('2011-1-3','YYYY-MM-DD')),
PARTITION part_4 VALUES LESS THAN (TO_DATE('2011-1-4','YYYY-MM-DD')),
PARTITION part_5 VALUES LESS THAN (TO_DATE('2011-1-5','YYYY-MM-DD')),
PARTITION part_6 VALUES LESS THAN (TO_DATE('2011-1-6','YYYY-MM-DD')),
PARTITION part_7 VALUES LESS THAN (TO_DATE('2011-1-7','YYYY-MM-DD')),
PARTITION part_8 VALUES LESS THAN (TO_DATE('2011-1-8','YYYY-MM-DD')),
PARTITION part_9 VALUES LESS THAN (TO_DATE('2011-1-9','YYYY-MM-DD')),
PARTITION part_10 VALUES LESS THAN (TO_DATE('2011-1-10','YYYY-MM-DD')),
PARTITION part_11 VALUES LESS THAN (TO_DATE('2011-1-11','YYYY-MM-DD')),
PARTITION part_12 VALUES LESS THAN (TO_DATE('2011-1-12','YYYY-MM-DD')),
PARTITION part_13 VALUES LESS THAN (TO_DATE('2011-1-13','YYYY-MM-DD')),
PARTITION part_14 VALUES LESS THAN (TO_DATE('2011-1-14','YYYY-MM-DD')),
PARTITION part_15 VALUES LESS THAN (TO_DATE('2011-1-15','YYYY-MM-DD')),
PARTITION part_16 VALUES LESS THAN (TO_DATE('2011-1-16','YYYY-MM-DD')),
PARTITION part_17 VALUES LESS THAN (TO_DATE('2011-1-17','YYYY-MM-DD')),
PARTITION part_18 VALUES LESS THAN (TO_DATE('2011-1-18','YYYY-MM-DD')),
PARTITION part_19 VALUES LESS THAN (TO_DATE('2011-1-19','YYYY-MM-DD')),
PARTITION part_20 VALUES LESS THAN (TO_DATE('2011-1-20','YYYY-MM-DD')),
PARTITION part_21 VALUES LESS THAN (TO_DATE('2011-1-21','YYYY-MM-DD')),
PARTITION part_22 VALUES LESS THAN (TO_DATE('2011-1-22','YYYY-MM-DD')),
PARTITION part_23 VALUES LESS THAN (TO_DATE('2011-1-23','YYYY-MM-DD')),
PARTITION part_24 VALUES LESS THAN (TO_DATE('2011-1-24','YYYY-MM-DD')),
PARTITION part_25 VALUES LESS THAN (TO_DATE('2011-1-25','YYYY-MM-DD')),
PARTITION part_26 VALUES LESS THAN (TO_DATE('2011-1-26','YYYY-MM-DD')),
PARTITION part_27 VALUES LESS THAN (TO_DATE('2011-1-27','YYYY-MM-DD')),
PARTITION part_28 VALUES LESS THAN (TO_DATE('2011-1-28','YYYY-MM-DD')),
PARTITION part_29 VALUES LESS THAN (TO_DATE('2011-1-29','YYYY-MM-DD')),
PARTITION part_30 VALUES LESS THAN (TO_DATE('2011-1-30','YYYY-MM-DD')),
PARTITION part_31 VALUES LESS THAN (TO_DATE('2011-1-31','YYYY-MM-DD')),
PARTITION part_32 VALUES LESS THAN (TO_DATE('2011-2-1','YYYY-MM-DD')),
PARTITION part_33 VALUES LESS THAN (TO_DATE('2011-2-2','YYYY-MM-DD')),
PARTITION part_34 VALUES LESS THAN (TO_DATE('2011-2-3','YYYY-MM-DD')),
PARTITION part_35 VALUES LESS THAN (TO_DATE('2011-2-4','YYYY-MM-DD')),
PARTITION part_36 VALUES LESS THAN (TO_DATE('2011-2-5','YYYY-MM-DD')),
PARTITION part_37 VALUES LESS THAN (TO_DATE('2011-2-6','YYYY-MM-DD')),
PARTITION part_38 VALUES LESS THAN (TO_DATE('2011-2-7','YYYY-MM-DD')),
PARTITION part_39 VALUES LESS THAN (TO_DATE('2011-2-8','YYYY-MM-DD')),
PARTITION part_40 VALUES LESS THAN (TO_DATE('2011-2-9','YYYY-MM-DD')),
PARTITION part_41 VALUES LESS THAN (TO_DATE('2011-2-10','YYYY-MM-DD')),
PARTITION part_42 VALUES LESS THAN (TO_DATE('2011-2-11','YYYY-MM-DD')),
PARTITION part_43 VALUES LESS THAN (TO_DATE('2011-2-12','YYYY-MM-DD')),
PARTITION part_44 VALUES LESS THAN (TO_DATE('2011-2-13','YYYY-MM-DD')),
PARTITION part_45 VALUES LESS THAN (TO_DATE('2011-2-14','YYYY-MM-DD')),
PARTITION part_46 VALUES LESS THAN (TO_DATE('2011-2-15','YYYY-MM-DD')),
PARTITION part_47 VALUES LESS THAN (TO_DATE('2011-2-16','YYYY-MM-DD')),
PARTITION part_48 VALUES LESS THAN (TO_DATE('2011-2-17','YYYY-MM-DD')),
PARTITION part_49 VALUES LESS THAN (TO_DATE('2011-2-18','YYYY-MM-DD')),
PARTITION part_50 VALUES LESS THAN (TO_DATE('2011-2-19','YYYY-MM-DD')),
PARTITION part_51 VALUES LESS THAN (TO_DATE('2011-2-20','YYYY-MM-DD')),
PARTITION part_52 VALUES LESS THAN (TO_DATE('2011-2-21','YYYY-MM-DD')),
PARTITION part_53 VALUES LESS THAN (TO_DATE('2011-2-22','YYYY-MM-DD')),
PARTITION part_54 VALUES LESS THAN (TO_DATE('2011-2-23','YYYY-MM-DD')),
PARTITION part_55 VALUES LESS THAN (TO_DATE('2011-2-24','YYYY-MM-DD')),
PARTITION part_56 VALUES LESS THAN (TO_DATE('2011-2-25','YYYY-MM-DD')),
PARTITION part_57 VALUES LESS THAN (TO_DATE('2011-2-26','YYYY-MM-DD')),
PARTITION part_58 VALUES LESS THAN (TO_DATE('2011-2-27','YYYY-MM-DD')),
PARTITION part_59 VALUES LESS THAN (TO_DATE('2011-2-28','YYYY-MM-DD')),
PARTITION part_60 VALUES LESS THAN (TO_DATE('2011-3-1','YYYY-MM-DD')),
PARTITION part_61 VALUES LESS THAN (TO_DATE('2011-3-2','YYYY-MM-DD')),
PARTITION part_62 VALUES LESS THAN (TO_DATE('2011-3-3','YYYY-MM-DD')),
PARTITION part_63 VALUES LESS THAN (TO_DATE('2011-3-4','YYYY-MM-DD')),
PARTITION part_64 VALUES LESS THAN (TO_DATE('2011-3-5','YYYY-MM-DD')),
PARTITION part_65 VALUES LESS THAN (TO_DATE('2011-3-6','YYYY-MM-DD')),
PARTITION part_66 VALUES LESS THAN (TO_DATE('2011-3-7','YYYY-MM-DD')),
PARTITION part_67 VALUES LESS THAN (TO_DATE('2011-3-8','YYYY-MM-DD')),
PARTITION part_68 VALUES LESS THAN (TO_DATE('2011-3-9','YYYY-MM-DD')),
PARTITION part_69 VALUES LESS THAN (TO_DATE('2011-3-10','YYYY-MM-DD')),
PARTITION part_70 VALUES LESS THAN (TO_DATE('2011-3-11','YYYY-MM-DD')),
PARTITION part_71 VALUES LESS THAN (TO_DATE('2011-3-12','YYYY-MM-DD')),
PARTITION part_72 VALUES LESS THAN (TO_DATE('2011-3-13','YYYY-MM-DD')),
PARTITION part_73 VALUES LESS THAN (TO_DATE('2011-3-14','YYYY-MM-DD')),
PARTITION part_74 VALUES LESS THAN (TO_DATE('2011-3-15','YYYY-MM-DD')),
PARTITION part_75 VALUES LESS THAN (TO_DATE('2011-3-16','YYYY-MM-DD')),
PARTITION part_76 VALUES LESS THAN (TO_DATE('2011-3-17','YYYY-MM-DD')),
PARTITION part_77 VALUES LESS THAN (TO_DATE('2011-3-18','YYYY-MM-DD')),
PARTITION part_78 VALUES LESS THAN (TO_DATE('2011-3-19','YYYY-MM-DD')),
PARTITION part_79 VALUES LESS THAN (TO_DATE('2011-3-20','YYYY-MM-DD')),
PARTITION part_80 VALUES LESS THAN (TO_DATE('2011-3-21','YYYY-MM-DD')),
PARTITION part_81 VALUES LESS THAN (TO_DATE('2011-3-22','YYYY-MM-DD')),
PARTITION part_82 VALUES LESS THAN (TO_DATE('2011-3-23','YYYY-MM-DD')),
PARTITION part_83 VALUES LESS THAN (TO_DATE('2011-3-24','YYYY-MM-DD')),
PARTITION part_84 VALUES LESS THAN (TO_DATE('2011-3-25','YYYY-MM-DD')),
PARTITION part_85 VALUES LESS THAN (TO_DATE('2011-3-26','YYYY-MM-DD')),
PARTITION part_86 VALUES LESS THAN (TO_DATE('2011-3-27','YYYY-MM-DD')),
PARTITION part_87 VALUES LESS THAN (TO_DATE('2011-3-28','YYYY-MM-DD')),
PARTITION part_88 VALUES LESS THAN (TO_DATE('2011-3-29','YYYY-MM-DD')),
PARTITION part_89 VALUES LESS THAN (TO_DATE('2011-3-30','YYYY-MM-DD')),
PARTITION part_90 VALUES LESS THAN (TO_DATE('2011-3-31','YYYY-MM-DD')),
PARTITION part_91 VALUES LESS THAN (TO_DATE('2011-4-1','YYYY-MM-DD')),
PARTITION part_92 VALUES LESS THAN (TO_DATE('2011-4-2','YYYY-MM-DD')),
PARTITION part_93 VALUES LESS THAN (TO_DATE('2011-4-3','YYYY-MM-DD')),
PARTITION part_94 VALUES LESS THAN (TO_DATE('2011-4-4','YYYY-MM-DD')),
PARTITION part_95 VALUES LESS THAN (TO_DATE('2011-4-5','YYYY-MM-DD')),
PARTITION part_96 VALUES LESS THAN (TO_DATE('2011-4-6','YYYY-MM-DD')),
PARTITION part_97 VALUES LESS THAN (TO_DATE('2011-4-7','YYYY-MM-DD')),
PARTITION part_98 VALUES LESS THAN (TO_DATE('2011-4-8','YYYY-MM-DD')),
PARTITION part_99 VALUES LESS THAN (TO_DATE('2011-4-9','YYYY-MM-DD')),
PARTITION part_100 VALUES LESS THAN (TO_DATE('2011-4-10','YYYY-MM-DD')),
PARTITION part_101 VALUES LESS THAN (TO_DATE('2011-4-11','YYYY-MM-DD')),
PARTITION part_102 VALUES LESS THAN (TO_DATE('2011-4-12','YYYY-MM-DD')),
PARTITION part_103 VALUES LESS THAN (TO_DATE('2011-4-13','YYYY-MM-DD')),
PARTITION part_104 VALUES LESS THAN (TO_DATE('2011-4-14','YYYY-MM-DD')),
PARTITION part_105 VALUES LESS THAN (TO_DATE('2011-4-15','YYYY-MM-DD')),
PARTITION part_106 VALUES LESS THAN (TO_DATE('2011-4-16','YYYY-MM-DD')),
PARTITION part_107 VALUES LESS THAN (TO_DATE('2011-4-17','YYYY-MM-DD')),
PARTITION part_108 VALUES LESS THAN (TO_DATE('2011-4-18','YYYY-MM-DD')),
PARTITION part_109 VALUES LESS THAN (TO_DATE('2011-4-19','YYYY-MM-DD')),
PARTITION part_110 VALUES LESS THAN (TO_DATE('2011-4-20','YYYY-MM-DD')),
PARTITION part_111 VALUES LESS THAN (TO_DATE('2011-4-21','YYYY-MM-DD')),
PARTITION part_112 VALUES LESS THAN (TO_DATE('2011-4-22','YYYY-MM-DD')),
PARTITION part_113 VALUES LESS THAN (TO_DATE('2011-4-23','YYYY-MM-DD')),
PARTITION part_114 VALUES LESS THAN (TO_DATE('2011-4-24','YYYY-MM-DD')),
PARTITION part_115 VALUES LESS THAN (TO_DATE('2011-4-25','YYYY-MM-DD')),
PARTITION part_116 VALUES LESS THAN (TO_DATE('2011-4-26','YYYY-MM-DD')),
PARTITION part_117 VALUES LESS THAN (TO_DATE('2011-4-27','YYYY-MM-DD')),
PARTITION part_118 VALUES LESS THAN (TO_DATE('2011-4-28','YYYY-MM-DD')),
PARTITION part_119 VALUES LESS THAN (TO_DATE('2011-4-29','YYYY-MM-DD')),
PARTITION part_120 VALUES LESS THAN (TO_DATE('2011-4-30','YYYY-MM-DD')),
PARTITION part_122 VALUES LESS THAN (TO_DATE('2011-5-2','YYYY-MM-DD')),
PARTITION part_123 VALUES LESS THAN (TO_DATE('2011-5-3','YYYY-MM-DD')),
PARTITION part_124 VALUES LESS THAN (TO_DATE('2011-5-4','YYYY-MM-DD')),
PARTITION part_125 VALUES LESS THAN (TO_DATE('2011-5-5','YYYY-MM-DD')),
PARTITION part_126 VALUES LESS THAN (TO_DATE('2011-5-6','YYYY-MM-DD')),
PARTITION part_127 VALUES LESS THAN (TO_DATE('2011-5-7','YYYY-MM-DD')),
PARTITION part_128 VALUES LESS THAN (TO_DATE('2011-5-8','YYYY-MM-DD')),
PARTITION part_129 VALUES LESS THAN (TO_DATE('2011-5-9','YYYY-MM-DD')),
PARTITION part_130 VALUES LESS THAN (TO_DATE('2011-5-10','YYYY-MM-DD')),
PARTITION part_131 VALUES LESS THAN (TO_DATE('2011-5-11','YYYY-MM-DD')),
PARTITION part_132 VALUES LESS THAN (TO_DATE('2011-5-12','YYYY-MM-DD')),
PARTITION part_133 VALUES LESS THAN (TO_DATE('2011-5-13','YYYY-MM-DD')),
PARTITION part_134 VALUES LESS THAN (TO_DATE('2011-5-14','YYYY-MM-DD')),
PARTITION part_135 VALUES LESS THAN (TO_DATE('2011-5-15','YYYY-MM-DD')),
PARTITION part_136 VALUES LESS THAN (TO_DATE('2011-5-16','YYYY-MM-DD')),
PARTITION part_137 VALUES LESS THAN (TO_DATE('2011-5-17','YYYY-MM-DD')),
PARTITION part_138 VALUES LESS THAN (TO_DATE('2011-5-18','YYYY-MM-DD')),
PARTITION part_139 VALUES LESS THAN (TO_DATE('2011-5-19','YYYY-MM-DD')),
PARTITION part_140 VALUES LESS THAN (TO_DATE('2011-5-20','YYYY-MM-DD')),
PARTITION part_141 VALUES LESS THAN (TO_DATE('2011-5-21','YYYY-MM-DD')),
PARTITION part_142 VALUES LESS THAN (TO_DATE('2011-5-22','YYYY-MM-DD')),
PARTITION part_143 VALUES LESS THAN (TO_DATE('2011-5-23','YYYY-MM-DD')),
PARTITION part_144 VALUES LESS THAN (TO_DATE('2011-5-24','YYYY-MM-DD')),
PARTITION part_145 VALUES LESS THAN (TO_DATE('2011-5-25','YYYY-MM-DD')),
PARTITION part_146 VALUES LESS THAN (TO_DATE('2011-5-26','YYYY-MM-DD')),
PARTITION part_147 VALUES LESS THAN (TO_DATE('2011-5-27','YYYY-MM-DD')),
PARTITION part_148 VALUES LESS THAN (TO_DATE('2011-5-28','YYYY-MM-DD')),
PARTITION part_149 VALUES LESS THAN (TO_DATE('2011-5-29','YYYY-MM-DD')),
PARTITION part_150 VALUES LESS THAN (TO_DATE('2011-5-30','YYYY-MM-DD')),
PARTITION part_151 VALUES LESS THAN (TO_DATE('2011-5-31','YYYY-MM-DD')),
PARTITION part_152 VALUES LESS THAN (TO_DATE('2011-6-1','YYYY-MM-DD')),
PARTITION part_153 VALUES LESS THAN (TO_DATE('2011-6-2','YYYY-MM-DD')),
PARTITION part_154 VALUES LESS THAN (TO_DATE('2011-6-3','YYYY-MM-DD')),
PARTITION part_155 VALUES LESS THAN (TO_DATE('2011-6-4','YYYY-MM-DD')),
PARTITION part_156 VALUES LESS THAN (TO_DATE('2011-6-5','YYYY-MM-DD')),
PARTITION part_157 VALUES LESS THAN (TO_DATE('2011-6-6','YYYY-MM-DD')),
PARTITION part_158 VALUES LESS THAN (TO_DATE('2011-6-7','YYYY-MM-DD')),
PARTITION part_159 VALUES LESS THAN (TO_DATE('2011-6-8','YYYY-MM-DD')),
PARTITION part_160 VALUES LESS THAN (TO_DATE('2011-6-9','YYYY-MM-DD')),
PARTITION part_161 VALUES LESS THAN (TO_DATE('2011-6-10','YYYY-MM-DD')),
PARTITION part_162 VALUES LESS THAN (TO_DATE('2011-6-11','YYYY-MM-DD')),
PARTITION part_163 VALUES LESS THAN (TO_DATE('2011-6-12','YYYY-MM-DD')),
PARTITION part_164 VALUES LESS THAN (TO_DATE('2011-6-13','YYYY-MM-DD')),
PARTITION part_165 VALUES LESS THAN (TO_DATE('2011-6-14','YYYY-MM-DD')),
PARTITION part_166 VALUES LESS THAN (TO_DATE('2011-6-15','YYYY-MM-DD')),
PARTITION part_167 VALUES LESS THAN (TO_DATE('2011-6-16','YYYY-MM-DD')),
PARTITION part_168 VALUES LESS THAN (TO_DATE('2011-6-17','YYYY-MM-DD')),
PARTITION part_169 VALUES LESS THAN (TO_DATE('2011-6-18','YYYY-MM-DD')),
PARTITION part_170 VALUES LESS THAN (TO_DATE('2011-6-19','YYYY-MM-DD')),
PARTITION part_171 VALUES LESS THAN (TO_DATE('2011-6-20','YYYY-MM-DD')),
PARTITION part_172 VALUES LESS THAN (TO_DATE('2011-6-21','YYYY-MM-DD')),
PARTITION part_173 VALUES LESS THAN (TO_DATE('2011-6-22','YYYY-MM-DD')),
PARTITION part_174 VALUES LESS THAN (TO_DATE('2011-6-23','YYYY-MM-DD')),
PARTITION part_175 VALUES LESS THAN (TO_DATE('2011-6-24','YYYY-MM-DD')),
PARTITION part_176 VALUES LESS THAN (TO_DATE('2011-6-25','YYYY-MM-DD')),
PARTITION part_177 VALUES LESS THAN (TO_DATE('2011-6-26','YYYY-MM-DD')),
PARTITION part_178 VALUES LESS THAN (TO_DATE('2011-6-27','YYYY-MM-DD')),
PARTITION part_179 VALUES LESS THAN (TO_DATE('2011-6-28','YYYY-MM-DD')),
PARTITION part_180 VALUES LESS THAN (TO_DATE('2011-6-29','YYYY-MM-DD')),
PARTITION part_181 VALUES LESS THAN (TO_DATE('2011-6-30','YYYY-MM-DD')),
PARTITION part_182 VALUES LESS THAN (TO_DATE('2011-7-1','YYYY-MM-DD')),
PARTITION part_183 VALUES LESS THAN (TO_DATE('2011-7-2','YYYY-MM-DD')),
PARTITION part_184 VALUES LESS THAN (TO_DATE('2011-7-3','YYYY-MM-DD')),
PARTITION part_185 VALUES LESS THAN (TO_DATE('2011-7-4','YYYY-MM-DD')),
PARTITION part_186 VALUES LESS THAN (TO_DATE('2011-7-5','YYYY-MM-DD')),
PARTITION part_187 VALUES LESS THAN (TO_DATE('2011-7-6','YYYY-MM-DD')),
PARTITION part_188 VALUES LESS THAN (TO_DATE('2011-7-7','YYYY-MM-DD')),
PARTITION part_189 VALUES LESS THAN (TO_DATE('2011-7-8','YYYY-MM-DD')),
PARTITION part_190 VALUES LESS THAN (TO_DATE('2011-7-9','YYYY-MM-DD')),
PARTITION part_191 VALUES LESS THAN (TO_DATE('2011-7-10','YYYY-MM-DD')),
PARTITION part_192 VALUES LESS THAN (TO_DATE('2011-7-11','YYYY-MM-DD')),
PARTITION part_193 VALUES LESS THAN (TO_DATE('2011-7-12','YYYY-MM-DD')),
PARTITION part_194 VALUES LESS THAN (TO_DATE('2011-7-13','YYYY-MM-DD')),
PARTITION part_195 VALUES LESS THAN (TO_DATE('2011-7-14','YYYY-MM-DD')),
PARTITION part_196 VALUES LESS THAN (TO_DATE('2011-7-15','YYYY-MM-DD')),
PARTITION part_197 VALUES LESS THAN (TO_DATE('2011-7-16','YYYY-MM-DD')),
PARTITION part_198 VALUES LESS THAN (TO_DATE('2011-7-17','YYYY-MM-DD')),
PARTITION part_199 VALUES LESS THAN (TO_DATE('2011-7-18','YYYY-MM-DD')),
PARTITION part_200 VALUES LESS THAN (TO_DATE('2011-7-19','YYYY-MM-DD')),
PARTITION part_201 VALUES LESS THAN (TO_DATE('2011-7-20','YYYY-MM-DD')),
PARTITION part_202 VALUES LESS THAN (TO_DATE('2011-7-21','YYYY-MM-DD')),
PARTITION part_203 VALUES LESS THAN (TO_DATE('2011-7-22','YYYY-MM-DD')),
PARTITION part_204 VALUES LESS THAN (TO_DATE('2011-7-23','YYYY-MM-DD')),
PARTITION part_205 VALUES LESS THAN (TO_DATE('2011-7-24','YYYY-MM-DD')),
PARTITION part_206 VALUES LESS THAN (TO_DATE('2011-7-25','YYYY-MM-DD')),
PARTITION part_207 VALUES LESS THAN (TO_DATE('2011-7-26','YYYY-MM-DD')),
PARTITION part_208 VALUES LESS THAN (TO_DATE('2011-7-27','YYYY-MM-DD')),
PARTITION part_209 VALUES LESS THAN (TO_DATE('2011-7-28','YYYY-MM-DD')),
PARTITION part_210 VALUES LESS THAN (TO_DATE('2011-7-29','YYYY-MM-DD')),
PARTITION part_211 VALUES LESS THAN (TO_DATE('2011-7-30','YYYY-MM-DD')),
PARTITION part_212 VALUES LESS THAN (TO_DATE('2011-7-31','YYYY-MM-DD')),
PARTITION part_213 VALUES LESS THAN (TO_DATE('2011-8-1','YYYY-MM-DD')),
PARTITION part_214 VALUES LESS THAN (TO_DATE('2011-8-2','YYYY-MM-DD')),
PARTITION part_215 VALUES LESS THAN (TO_DATE('2011-8-3','YYYY-MM-DD')),
PARTITION part_216 VALUES LESS THAN (TO_DATE('2011-8-4','YYYY-MM-DD')),
PARTITION part_217 VALUES LESS THAN (TO_DATE('2011-8-5','YYYY-MM-DD')),
PARTITION part_218 VALUES LESS THAN (TO_DATE('2011-8-6','YYYY-MM-DD')),
PARTITION part_219 VALUES LESS THAN (TO_DATE('2011-8-7','YYYY-MM-DD')),
PARTITION part_220 VALUES LESS THAN (TO_DATE('2011-8-8','YYYY-MM-DD')),
PARTITION part_221 VALUES LESS THAN (TO_DATE('2011-8-9','YYYY-MM-DD')),
PARTITION part_222 VALUES LESS THAN (TO_DATE('2011-8-10','YYYY-MM-DD')),
PARTITION part_223 VALUES LESS THAN (TO_DATE('2011-8-11','YYYY-MM-DD')),
PARTITION part_224 VALUES LESS THAN (TO_DATE('2011-8-12','YYYY-MM-DD')),
PARTITION part_225 VALUES LESS THAN (TO_DATE('2011-8-13','YYYY-MM-DD')),
PARTITION part_226 VALUES LESS THAN (TO_DATE('2011-8-14','YYYY-MM-DD')),
PARTITION part_227 VALUES LESS THAN (TO_DATE('2011-8-15','YYYY-MM-DD')),
PARTITION part_228 VALUES LESS THAN (TO_DATE('2011-8-16','YYYY-MM-DD')),
PARTITION part_229 VALUES LESS THAN (TO_DATE('2011-8-17','YYYY-MM-DD')),
PARTITION part_230 VALUES LESS THAN (TO_DATE('2011-8-18','YYYY-MM-DD')),
PARTITION part_231 VALUES LESS THAN (TO_DATE('2011-8-19','YYYY-MM-DD')),
PARTITION part_232 VALUES LESS THAN (TO_DATE('2011-8-20','YYYY-MM-DD')),
PARTITION part_233 VALUES LESS THAN (TO_DATE('2011-8-21','YYYY-MM-DD')),
PARTITION part_234 VALUES LESS THAN (TO_DATE('2011-8-22','YYYY-MM-DD')),
PARTITION part_235 VALUES LESS THAN (TO_DATE('2011-8-23','YYYY-MM-DD')),
PARTITION part_236 VALUES LESS THAN (TO_DATE('2011-8-24','YYYY-MM-DD')),
PARTITION part_237 VALUES LESS THAN (TO_DATE('2011-8-25','YYYY-MM-DD')),
PARTITION part_238 VALUES LESS THAN (TO_DATE('2011-8-26','YYYY-MM-DD')),
PARTITION part_239 VALUES LESS THAN (TO_DATE('2011-8-27','YYYY-MM-DD')),
PARTITION part_240 VALUES LESS THAN (TO_DATE('2011-8-28','YYYY-MM-DD')),
PARTITION part_241 VALUES LESS THAN (TO_DATE('2011-8-29','YYYY-MM-DD')),
PARTITION part_242 VALUES LESS THAN (TO_DATE('2011-8-30','YYYY-MM-DD')),
PARTITION part_244 VALUES LESS THAN (TO_DATE('2011-9-1','YYYY-MM-DD')),
PARTITION part_245 VALUES LESS THAN (TO_DATE('2011-9-2','YYYY-MM-DD')),
PARTITION part_246 VALUES LESS THAN (TO_DATE('2011-9-3','YYYY-MM-DD')),
PARTITION part_247 VALUES LESS THAN (TO_DATE('2011-9-4','YYYY-MM-DD')),
PARTITION part_248 VALUES LESS THAN (TO_DATE('2011-9-5','YYYY-MM-DD')),
PARTITION part_249 VALUES LESS THAN (TO_DATE('2011-9-6','YYYY-MM-DD')),
PARTITION part_250 VALUES LESS THAN (TO_DATE('2011-9-7','YYYY-MM-DD')),
PARTITION part_251 VALUES LESS THAN (TO_DATE('2011-9-8','YYYY-MM-DD')),
PARTITION part_252 VALUES LESS THAN (TO_DATE('2011-9-9','YYYY-MM-DD')),
PARTITION part_253 VALUES LESS THAN (TO_DATE('2011-9-10','YYYY-MM-DD')),
PARTITION part_254 VALUES LESS THAN (TO_DATE('2011-9-11','YYYY-MM-DD')),
PARTITION part_255 VALUES LESS THAN (TO_DATE('2011-9-12','YYYY-MM-DD')),
PARTITION part_256 VALUES LESS THAN (TO_DATE('2011-9-13','YYYY-MM-DD')),
PARTITION part_257 VALUES LESS THAN (TO_DATE('2011-9-14','YYYY-MM-DD')),
PARTITION part_258 VALUES LESS THAN (TO_DATE('2011-9-15','YYYY-MM-DD')),
PARTITION part_259 VALUES LESS THAN (TO_DATE('2011-9-16','YYYY-MM-DD')),
PARTITION part_260 VALUES LESS THAN (TO_DATE('2011-9-17','YYYY-MM-DD')),
PARTITION part_261 VALUES LESS THAN (TO_DATE('2011-9-18','YYYY-MM-DD')),
PARTITION part_262 VALUES LESS THAN (TO_DATE('2011-9-19','YYYY-MM-DD')),
PARTITION part_263 VALUES LESS THAN (TO_DATE('2011-9-20','YYYY-MM-DD')),
PARTITION part_264 VALUES LESS THAN (TO_DATE('2011-9-21','YYYY-MM-DD')),
PARTITION part_265 VALUES LESS THAN (TO_DATE('2011-9-22','YYYY-MM-DD')),
PARTITION part_266 VALUES LESS THAN (TO_DATE('2011-9-23','YYYY-MM-DD')),
PARTITION part_267 VALUES LESS THAN (TO_DATE('2011-9-24','YYYY-MM-DD')),
PARTITION part_268 VALUES LESS THAN (TO_DATE('2011-9-25','YYYY-MM-DD')),
PARTITION part_269 VALUES LESS THAN (TO_DATE('2011-9-26','YYYY-MM-DD')),
PARTITION part_270 VALUES LESS THAN (TO_DATE('2011-9-27','YYYY-MM-DD')),
PARTITION part_271 VALUES LESS THAN (TO_DATE('2011-9-28','YYYY-MM-DD')),
PARTITION part_272 VALUES LESS THAN (TO_DATE('2011-9-29','YYYY-MM-DD')),
PARTITION part_273 VALUES LESS THAN (TO_DATE('2011-9-30','YYYY-MM-DD')),
PARTITION part_274 VALUES LESS THAN (TO_DATE('2011-10-1','YYYY-MM-DD')),
PARTITION part_275 VALUES LESS THAN (TO_DATE('2011-10-2','YYYY-MM-DD')),
PARTITION part_276 VALUES LESS THAN (TO_DATE('2011-10-3','YYYY-MM-DD')),
PARTITION part_277 VALUES LESS THAN (TO_DATE('2011-10-4','YYYY-MM-DD')),
PARTITION part_278 VALUES LESS THAN (TO_DATE('2011-10-5','YYYY-MM-DD')),
PARTITION part_279 VALUES LESS THAN (TO_DATE('2011-10-6','YYYY-MM-DD')),
PARTITION part_280 VALUES LESS THAN (TO_DATE('2011-10-7','YYYY-MM-DD')),
PARTITION part_281 VALUES LESS THAN (TO_DATE('2011-10-8','YYYY-MM-DD')),
PARTITION part_282 VALUES LESS THAN (TO_DATE('2011-10-9','YYYY-MM-DD')),
PARTITION part_283 VALUES LESS THAN (TO_DATE('2011-10-10','YYYY-MM-DD')),
PARTITION part_284 VALUES LESS THAN (TO_DATE('2011-10-11','YYYY-MM-DD')),
PARTITION part_285 VALUES LESS THAN (TO_DATE('2011-10-12','YYYY-MM-DD')),
PARTITION part_286 VALUES LESS THAN (TO_DATE('2011-10-13','YYYY-MM-DD')),
PARTITION part_287 VALUES LESS THAN (TO_DATE('2011-10-14','YYYY-MM-DD')),
PARTITION part_288 VALUES LESS THAN (TO_DATE('2011-10-15','YYYY-MM-DD')),
PARTITION part_289 VALUES LESS THAN (TO_DATE('2011-10-16','YYYY-MM-DD')),
PARTITION part_290 VALUES LESS THAN (TO_DATE('2011-10-17','YYYY-MM-DD')),
PARTITION part_291 VALUES LESS THAN (TO_DATE('2011-10-18','YYYY-MM-DD')),
PARTITION part_292 VALUES LESS THAN (TO_DATE('2011-10-19','YYYY-MM-DD')),
PARTITION part_293 VALUES LESS THAN (TO_DATE('2011-10-20','YYYY-MM-DD')),
PARTITION part_294 VALUES LESS THAN (TO_DATE('2011-10-21','YYYY-MM-DD')),
PARTITION part_295 VALUES LESS THAN (TO_DATE('2011-10-22','YYYY-MM-DD')),
PARTITION part_296 VALUES LESS THAN (TO_DATE('2011-10-23','YYYY-MM-DD')),
PARTITION part_297 VALUES LESS THAN (TO_DATE('2011-10-24','YYYY-MM-DD')),
PARTITION part_298 VALUES LESS THAN (TO_DATE('2011-10-25','YYYY-MM-DD')),
PARTITION part_299 VALUES LESS THAN (TO_DATE('2011-10-26','YYYY-MM-DD')),
PARTITION part_300 VALUES LESS THAN (TO_DATE('2011-10-27','YYYY-MM-DD')),
PARTITION part_301 VALUES LESS THAN (TO_DATE('2011-10-28','YYYY-MM-DD')),
PARTITION part_302 VALUES LESS THAN (TO_DATE('2011-10-29','YYYY-MM-DD')),
PARTITION part_303 VALUES LESS THAN (TO_DATE('2011-10-30','YYYY-MM-DD')),
PARTITION part_304 VALUES LESS THAN (TO_DATE('2011-10-31','YYYY-MM-DD')),
PARTITION part_305 VALUES LESS THAN (TO_DATE('2011-11-1','YYYY-MM-DD')),
PARTITION part_306 VALUES LESS THAN (TO_DATE('2011-11-2','YYYY-MM-DD')),
PARTITION part_307 VALUES LESS THAN (TO_DATE('2011-11-3','YYYY-MM-DD')),
PARTITION part_308 VALUES LESS THAN (TO_DATE('2011-11-4','YYYY-MM-DD')),
PARTITION part_309 VALUES LESS THAN (TO_DATE('2011-11-5','YYYY-MM-DD')),
PARTITION part_310 VALUES LESS THAN (TO_DATE('2011-11-6','YYYY-MM-DD')),
PARTITION part_311 VALUES LESS THAN (TO_DATE('2011-11-7','YYYY-MM-DD')),
PARTITION part_312 VALUES LESS THAN (TO_DATE('2011-11-8','YYYY-MM-DD')),
PARTITION part_313 VALUES LESS THAN (TO_DATE('2011-11-9','YYYY-MM-DD')),
PARTITION part_314 VALUES LESS THAN (TO_DATE('2011-11-10','YYYY-MM-DD')),
PARTITION part_315 VALUES LESS THAN (TO_DATE('2011-11-11','YYYY-MM-DD')),
PARTITION part_316 VALUES LESS THAN (TO_DATE('2011-11-12','YYYY-MM-DD')),
PARTITION part_317 VALUES LESS THAN (TO_DATE('2011-11-13','YYYY-MM-DD')),
PARTITION part_318 VALUES LESS THAN (TO_DATE('2011-11-14','YYYY-MM-DD')),
PARTITION part_319 VALUES LESS THAN (TO_DATE('2011-11-15','YYYY-MM-DD')),
PARTITION part_320 VALUES LESS THAN (TO_DATE('2011-11-16','YYYY-MM-DD')),
PARTITION part_321 VALUES LESS THAN (TO_DATE('2011-11-17','YYYY-MM-DD')),
PARTITION part_322 VALUES LESS THAN (TO_DATE('2011-11-18','YYYY-MM-DD')),
PARTITION part_323 VALUES LESS THAN (TO_DATE('2011-11-19','YYYY-MM-DD')),
PARTITION part_324 VALUES LESS THAN (TO_DATE('2011-11-20','YYYY-MM-DD')),
PARTITION part_325 VALUES LESS THAN (TO_DATE('2011-11-21','YYYY-MM-DD')),
PARTITION part_326 VALUES LESS THAN (TO_DATE('2011-11-22','YYYY-MM-DD')),
PARTITION part_327 VALUES LESS THAN (TO_DATE('2011-11-23','YYYY-MM-DD')),
PARTITION part_328 VALUES LESS THAN (TO_DATE('2011-11-24','YYYY-MM-DD')),
PARTITION part_329 VALUES LESS THAN (TO_DATE('2011-11-25','YYYY-MM-DD')),
PARTITION part_330 VALUES LESS THAN (TO_DATE('2011-11-26','YYYY-MM-DD')),
PARTITION part_331 VALUES LESS THAN (TO_DATE('2011-11-27','YYYY-MM-DD')),
PARTITION part_332 VALUES LESS THAN (TO_DATE('2011-11-28','YYYY-MM-DD')),
PARTITION part_333 VALUES LESS THAN (TO_DATE('2011-11-29','YYYY-MM-DD')),
PARTITION part_334 VALUES LESS THAN (TO_DATE('2011-11-30','YYYY-MM-DD')),
PARTITION part_335 VALUES LESS THAN (TO_DATE('2011-12-1','YYYY-MM-DD')),
PARTITION part_336 VALUES LESS THAN (TO_DATE('2011-12-2','YYYY-MM-DD')),
PARTITION part_337 VALUES LESS THAN (TO_DATE('2011-12-3','YYYY-MM-DD')),
PARTITION part_338 VALUES LESS THAN (TO_DATE('2011-12-4','YYYY-MM-DD')),
PARTITION part_339 VALUES LESS THAN (TO_DATE('2011-12-5','YYYY-MM-DD')),
PARTITION part_340 VALUES LESS THAN (TO_DATE('2011-12-6','YYYY-MM-DD')),
PARTITION part_341 VALUES LESS THAN (TO_DATE('2011-12-7','YYYY-MM-DD')),
PARTITION part_342 VALUES LESS THAN (TO_DATE('2011-12-8','YYYY-MM-DD')),
PARTITION part_343 VALUES LESS THAN (TO_DATE('2011-12-9','YYYY-MM-DD')),
PARTITION part_344 VALUES LESS THAN (TO_DATE('2011-12-10','YYYY-MM-DD')),
PARTITION part_345 VALUES LESS THAN (TO_DATE('2011-12-11','YYYY-MM-DD')),
PARTITION part_346 VALUES LESS THAN (TO_DATE('2011-12-12','YYYY-MM-DD')),
PARTITION part_347 VALUES LESS THAN (TO_DATE('2011-12-13','YYYY-MM-DD')),
PARTITION part_348 VALUES LESS THAN (TO_DATE('2011-12-14','YYYY-MM-DD')),
PARTITION part_349 VALUES LESS THAN (TO_DATE('2011-12-15','YYYY-MM-DD')),
PARTITION part_350 VALUES LESS THAN (TO_DATE('2011-12-16','YYYY-MM-DD')),
PARTITION part_351 VALUES LESS THAN (TO_DATE('2011-12-17','YYYY-MM-DD')),
PARTITION part_352 VALUES LESS THAN (TO_DATE('2011-12-18','YYYY-MM-DD')),
PARTITION part_353 VALUES LESS THAN (TO_DATE('2011-12-19','YYYY-MM-DD')),
PARTITION part_354 VALUES LESS THAN (TO_DATE('2011-12-20','YYYY-MM-DD')),
PARTITION part_355 VALUES LESS THAN (TO_DATE('2011-12-21','YYYY-MM-DD')),
PARTITION part_356 VALUES LESS THAN (TO_DATE('2011-12-22','YYYY-MM-DD')),
PARTITION part_357 VALUES LESS THAN (TO_DATE('2011-12-23','YYYY-MM-DD')),
PARTITION part_358 VALUES LESS THAN (TO_DATE('2011-12-24','YYYY-MM-DD')),
PARTITION part_359 VALUES LESS THAN (TO_DATE('2011-12-25','YYYY-MM-DD')),
PARTITION part_360 VALUES LESS THAN (TO_DATE('2011-12-26','YYYY-MM-DD')),
PARTITION part_361 VALUES LESS THAN (TO_DATE('2011-12-27','YYYY-MM-DD')),
PARTITION part_362 VALUES LESS THAN (TO_DATE('2011-12-28','YYYY-MM-DD')),
PARTITION part_363 VALUES LESS THAN (TO_DATE('2011-12-29','YYYY-MM-DD')),
PARTITION part_364 VALUES LESS THAN (TO_DATE('2011-12-30','YYYY-MM-DD')),
PARTITION part_365 VALUES LESS THAN (TO_DATE('2011-12-31','YYYY-MM-DD')),
PARTITION part_366 VALUES LESS THAN (TO_DATE('2012-1-1','YYYY-MM-DD')),
PARTITION part_max VALUES LESS THAN (MAXVALUE) );
-- 最后执行成功：......386 PARTITION part_363 VALUES LESS THAN (TO_DATE('2011-12-29','YYYY-MM-DD')),
387 PARTITION part_364 VALUES LESS THAN (TO_DATE('2011-12-30','YYYY-MM-DD')),
388 PARTITION part_365 VALUES LESS THAN (TO_DATE('2011-12-31','YYYY-MM-DD')),
389 PARTITION part_366 VALUES LESS THAN (TO_DATE('2012-1-1','YYYY-MM-DD')),
390 PARTITION part_max VALUES LESS THAN (MAXVALUE) );表已创建。scott@TBWORA>