create or replace PACKAGE BODY TRUNCATE_PKG AS PROCEDURE TRUNCATE_TABLE (p_table_name IN VARCHAR2,p_partition_name IN VARCHAR2,p_sleep IN NUMBER) AS BEGIN EXECUTE IMMEDIATE 'ALTER TABLE ' || p_table_name || ' TRUNCATE PARTITION ' || p_partition_name ; dbms_lock.sleep(p_sleep); END TRUNCATE_TABLE; END TRUNCATE_PKG;
choti wrote:No, I can't, because I don't have your table. You have your table, so you can see if it works or not.
i have written the following package to truncate table partition and sleep for 30seconds. Could you let me know whether it works or not.