Re: Remove archivelog files on NT

From: Adrian J. Shepherd <theshepherds_at_hotmail.com>
Date: 2000/04/25
Message-ID: <qAoN4.12786$r6.42797@stones>#1/1

The only way I managed to do this was to quick and dirty via a batch file using output from SQL*Plus and a query on V$archived_log... i.e.
SQL> SET...
SQL > SPOOL DELARC.BAT
SQL> select 'del '||name||' /Y' from v$archived_log where completion_time < sysdate -21;

SQL> SPOOL OFF
SQL> HOST DELARC.BAT
SQL> EXIT

Probably long winded and cranky but if you are stuck for any other solution. Also, check the validity of v$archived_log, can't remember if it replaced or was replaced by another view.

"NeilC" <neil-olos_at_NOSPAMbt.com> wrote in message news:3905C71A.82AD2064_at_NOSPAMbt.com...
> Hi,
>
> is there a way (similar to using find on unix) to delete archivelog
> files older than a certain number of days under NT ?
>
> Perhaps someone has a Perl script, or are there NT resource kit
> utilities that will let me do this.
>
> Any help appreciated.
>
> regards
>
> Neilc
Received on Tue Apr 25 2000 - 00:00:00 CDT