PRC_S_TRUNCATE_PARTITION

来源：互联网发布：俾斯麦号战列舰数据编辑：程序博客网时间：2024/05/30 07:14

CREATE OR REPLACE PROCEDURE LBI_SYS_VDF.PRC_S_TRUNCATE_PARTITION
(
    iv_schema         in varchar2,
    iv_table_name     in varchar2,
    iv_partition_type in varchar2,
    iv_date           in varchar2,
    oi_return         out integer
)
    /** head
      * @name LBI_SYS_VDF#prc_s_truncate_partition
      * @caption automatic management of partition by day
      * @type     primarily management program
      * @parameter iv_char_date in varchar2 deal date.formate:yyyymmdd
      * @parameter on_statuscode out number execute state: 0 means ok ; others means error.
      * @description automatic management of partition by day
      * @target LBI_SYS_VDF.t_s_tab_partition   table of partition information
      * @source all_table
      * @middle
      * @version 1.0.0
      * @author penghui
      * @create-date
      * @todo
      * @author
      * @create-date 2012-08-29
      * @description
      * @copyright huawei
      */
    authid current_user

0 0