表分区维护的sql(11)
来源:未知 责任编辑:责任编辑 发表时间:2015-10-08 14:16 点击:次
if (v_uniqueness = 'UNIQUE') then
v_sql := 'create unique index ' ||
fun_getTableName(v_index_name,
v_partitionflag,
v_in_date) || ' ON ' || v_bk_table_name ||
' ( ' || v_sql || ') tablespace IDX_CC';
else
v_sql := 'create index ' ||
fun_getTableName(v_index_name,
v_partitionflag,
v_in_date) || ' ON ' || v_bk_table_name ||
' ( ' || v_sql || ') tablespace IDX_CC';
end if;
EXECUTE IMMEDIATE v_sql;
EXCEPTION www.2cto.com
WHEN OTHERS THEN
raise;
end;
END LOOP;
CLOSE cur_all_index;
EXCEPTION
WHEN OTHERS THEN
if (cur_all_index_col%isopen) then
close cur_all_index_col;
end if;
if (cur_all_index%isopen) then
close cur_all_index;
end if;
raise;
END;
procedure pro_Dropbaktable(v_num number) as
V_ROW PARTITION_BAKTABLE%rowtype;
TYPE Tcur IS REF CURSOR;
cur_bakpartitiontable Tcur;
v_sql varchar2(4000);
v_version varchar2(6);
v_d_date varchar2(20);
BEGIN
select to_char(add_months(sysdate, -v_num), 'yyyymmddhh24miss')
into v_d_date www.2cto.com
相关新闻>>
最新推荐更多>>>
- 发表评论
-
- 最新评论 更多>>