Re: automatic arch log delete

From: <stephen.howard_at_us.pwcglobal.com>
Date: 12 Jul 2005 10:55:58 -0700
Message-ID: <1121190958.850877.312040@g49g2000cwa.googlegroups.com>

Try something like...

set serveroutput on size 1000000
declare
  l_base_dir varchar2(500);
begin
  for c in (select name

              from v$archived_log
              where next_time < sysdate - 3
                and dest_id = 1) loop

    l_base_dir := substr(c.name,1,instr(c.name,'\',-1,1)-1);     begin
      utl_file.fremove(l_base_dir,c.name);     exception

      when others then
        dbms_output.put_line(sqlerrm);

    end;
  end loop;
end;
/

Regards,

Steve Received on Tue Jul 12 2005 - 12:55:58 CDT