定期truncate 歷史間隔分區INTERVAL PARTITION 的SP：

CREATE OR REPLACE PROCEDURE GC.DROP_FATP_DIAG_COMM_NOW_PAR AS 
BEGIN
 FOR cc IN (SELECT partition_name, high_value
             FROM user_tab_partitions
             WHERE table_name = 'FATP_DIAG_COMM_NOW' and partition_name != 'SYS_P41') LOOP
     EXECUTE IMMEDIATE
        'BEGIN
            IF sysdate - 30 >= ' || cc.high_value || ' THEN
               EXECUTE IMMEDIATE
                  ''ALTER TABLE FATP_DIAG_COMM_NOW TRUNCATE PARTITION '
                  || cc.partition_name || '
                  '';
            END IF;
         END;';
  END LOOP;
END DROP_FATP_DIAG_COMM_NOW_PAR;
/