表分区维护的sql(8)
来源：未知 责任编辑：责任编辑 发表时间:2015-10-08 14:16 点击:次
v_comments := 'begin to maintenance table ' || v_row.table_name ||
', partitionflag:' || v_row.partitionflag ||
',retention_period:' || v_row.retention_period;
Pro_Record_Log(v_comments, v_comments);
v_rtn := pro_partition_maintenance(v_row.table_name,
v_partitionchar,
v_partition_name,
to_char(v_sysdate, 'YYYYMMDD'),
v_row.preprocess_flag,
v_row.preprocess_sql,
v_row.postprocess_flag,
v_row.postprocess_sql);
if (v_rtn = 0) then
v_comments := 'successful to maintenance table ' ||
v_row.table_name || ', partitionflag:' ||
v_row.partitionflag || ',retention_period:' ||
v_row.retention_period || ',maintenance partiton:' ||
v_partition_name;
else
v_comments := 'fail to maintenance table ' || v_row.table_name ||
', partitionflag:' || v_row.partitionflag ||
',retention_period:' || v_row.retention_period ||
',maintenance partiton:' || v_partition_name;
相关新闻>>
最新推荐更多>>>
- 发表评论
-
- 最新评论 更多>>
