[oracle] oracle定时清理回收站

1.创建回收站清理的存储过程 create or replace procedure purge_recyclebin as begin execute immediate 'purge dba_recyclebin'; end; / 2.创建定时任务 variable job number; begin   dbms_job.submit(:job,'purge_recyclebin;',trunc(sysdate,'hh24'),'trunc(sysdate+7,''hh24'')');   commit; end; / 3.确认job select * from dba_jobs;4.修改定时任务begin dbms_job.next_date(1, sysdate); end; / begin dbms_job.interval(1, 'trunc(sysdate,''hh'')+24*7+12/24'); end; /