oracle定时批量删表
----批量删临时表的存储过程和定时任务
#存储过程
create or replace procedure p_test3 is
begin
for x in (select t.table_name from user_tables t where table_name like ‘HNYJ_TEMP%’ and last_analyzed<sysdate-2) loop
execute immediate 'drop table '||x.table_name;
commit;
end loop;
end p_test3;
#定时任务
declare
job number;
begin
sys.dbms_job.submit(job => job,
what =>’ p_test3;’,
interval => ‘sysdate+5/(24*60)’); --5分钟扫描一次
commit;
end;