if cur_1%found then
--如果今天的最大分区不是 pyyyymmdd2350则从今天的最大分区的下一个分区作为起点,将今天的分区建完整
if to_date(v_maxpart,'yyyymmddhh24mi')+1/144 < TRUNC(sysdate + 1,'dd') then
v_beginHour := to_number(substr(to_char(to_date(v_maxpart,'yyyymmddhh24mi')+1/144, 'yyyymmddhh24mi'),9,2));
v_beginMin := substr(to_char(to_date(v_maxpart,'yyyymmddhh24mi')+1/144, 'yyyymmddhh24mi'),11,1);
--如果今天的最大分区是 pyyyymmdd2350,说明今天分区已经完整,进入明天分区判断
elsif to_date(v_maxpart,'yyyymmddhh24mi')+1/144 = TRUNC(sysdate + 1,'dd') then
sp_log('SP_AddPartitions_10Min ('||v_sTableName||')',null,2,'当天分区已完整存在',(sysdate-d_date)*24*60*60||'s');
v_todo:='判断明天的分区111';
--获取明天日期
v_dd := to_char(sysdate+1,'yyyymmdd');
v_sql :='SELECT substr(max(subPARTITION_NAME),2,12)
from user_tab_subpartitions
where table_name = ''' || upper(v_sTableName) || '''
and substr(partition_name,2,8)='''||v_dd||'''';