表分区维护的sql(2)

来源：未知责任编辑：责任编辑发表时间:2015-10-08 14:16　点击:次

v_sysdate varchar2) return varchar2;

PROCEDURE Pro_Create_Backup_Part_Indx(v_bk_table_name in varchar2,

v_partitionflag in varchar2,

v_table_name in varchar2,

v_in_date in VARCHAR2);

procedure pro_createbaktable(v_table_name in varchar2,

v_baktable in varchar2);

procedure PRO_DROPBAKTABLE(v_num number);

end P_PKG_partition_maintenance;

------------------包体

create or replace package body P_PKG_partition_maintenance is

--GRANT debug any procedure, debug connect session TO ccv68;

function pro_partition_maintenance(v_table_name varchar2,

v_partitionflag varchar2,

v_partition_name varchar2,

v_sysdate varchar2,

v_preprocessflag number,

v_preprocesssql varchar2,

v_postprocessflag number,

v_postprocesssql varchar2)

return number as

v_sql varchar2(4000);

v_baktable varchar2(30);

www.2cto.com

begin

--获取备份表名

v_baktable := fun_getTableName(v_table_name, v_partitionflag, v_sysdate);