oracle ·ÖÇø²ð·Ö ²»ÄܲåÈëÊý¾Ý 01502 Ë÷ÒýʧЧ

Êý¾Ý±íday_energyµ±Ç°ÎªÔ·ÖÇø±í£¬·ÖÇøÐÅÏ¢ÈçÏ£ºDE_200912,DE_201001,DE_201002.....,Ô·ÖÇø±í³öÏÖËٶȲéѯÂý£¬Òò´Ëͨ¹ý½¨Á¢ÈÕ·ÖÇø±í½øÐиÄÉÆ¡£
²ð·ÖÔ·ÖÇø±íµÄÓï¾äΪ£º
alter table day_energy split partition de_201001 at('20100102') into (partition de_20100101,partition de_20100102)
·ÖÎö£º
alter table ±íÃû split partition ·ÖÇøÃû at (·Ö¸îÈÕÆÚ) into (зÖÇø1£¬Ð·ÖÇø2)£»
Èç¹û¼òµ¥µÄ·ÖÇø1¸öÔÂµÄ±í£¬±È½Ï¼òµ¥£¬µ«ÊÇÈç¹ûÒª²ð·ÖÒ»ÄêµÄ±í£¬ÄǾÍÌ«¸´ÔÓÁË¡£ÎªÁ˼òµ¥ÊµÏÖËùÒÔ¾Íͨ¹ýÒÔÏÂÕâ¸ö¹ý³Ì½øÐÐÅúÁ¿²ð·Ö£º
-- czc ²ð·Ö·ÖÇø±í
--½«Ô·ÖÇø±í²ð·Ö³ÉÈÕ·ÖÇø±í
declare
  v_tbl     varchar2(56);
  v_partion varchar2(56);
  datetime  date;
  v_sql     varchar2(1024);
  v_dt0     varchar2(8);
  v_dt1     varchar2(8); 
begin
  datetime:=to_date('2010-11-1','yyyy-MM-dd');
  v_tbl:='day_energy';
  while to_char(datetime,'yyyyMMdd')!='20110101' loop
     if to_char(datetime,'MM')=to_char(datetime+1,'MM') then
       v_dt0:=to_char(datetime,'yyyyMMdd');
       v_dt1:=to_char(datetime+1,'yyyyMMdd');
       if to_number(to_char(datetime,'dd'))=1 then
        v_partion:='DE_'||to_char(datetime,'yyyyMM');
       else
        v_partion:='DE_'||to_char(datetime,'yyyyMMdd');
       end if;
       v_sql:='alter table '||v_tbl||' split partition '||v_partion||' at ('''||v_dt1||''') into (partition DE_'||v_dt0||', partition DE_'||v_dt1||');';
       dbms_output.put_line(v_sql);
       --execute immediate v_sql;
     end if;
     datetime:=datetime+1;
  end loop;
end;
µ«ÊdzöÎÊÌâÁË£¬·¢ÏÖda