表分区维护的sql(7)
来源：未知 责任编辑：责任编辑 发表时间:2015-10-08 14:16 点击:次
v_comments := 'when maintenancing ' || v_row.table_name ||
',MONTH_EXECUTION_DAY in partition_param is invalid. it''s must be [1-28].';
Pro_Record_Log(v_comments, v_comments);
goto here;
end if;
if (v_day = v_MonthExecution_DAY) then
v_partitionchar := Const_Partition_MONTH_prefix;
select 'P' || to_number(to_char(add_months(v_sysdate,
-v_row.retention_period),
'mm'))
into v_partition_name
from dual;
else
v_comments := 'it''s not a maintenance day..current day:' ||
v_day || ', maintenance day:' ||
v_MonthExecution_DAY || '. table ' ||
v_row.table_name || ', partitionflag:' ||
v_row.partitionflag || ',retention_period:' ||
v_row.retention_period;
Pro_Record_Log(v_comments, v_comments);
goto here;
end if;
else
v_comments := 'partition_flag:' || v_row.partitionflag ||
' of maintenance table :' || v_row.table_name ||
' in partition_table can''t be supported.';
Pro_Record_Log(v_comments, v_comments);
end if; www.2cto.com
相关新闻>>
最新推荐更多>>>
- 发表评论
-
- 最新评论 更多>>
