Re: Need script to copy and then truncate/tail alert log

You can use the OS cp and rm commands if it's UNIX. cp the alert log to a new place or name and the rm it. You can use the copy, and rename functions on NT too. Tail simply gives you the last rows of the table. You don't need to truncate it because it will recreate itself as necessary.

HTH,
Ruth
----- Original Message -----
From: <Cherie_Machler_at_gelco.com>
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Wednesday, July 26, 2000 11:40 AM
Subject: Need script to copy and then truncate/tail alert log

> Does anyone have a script that will copy over and then truncate or tail (I
can't
> remember if it's tail)
> the alert log? Or something appropriate to keep our alert log to a day's
worth
> of log information while
> keeping the file in the same directory (hopefully with a datestamp in the
old
> log file name). Then we
> want to clean out the old log files on a weekly or daily basis.
>
> Thanks in advance for any help.
>
> Cherie
>
>
> --
> Author:
> INET: Cherie_Machler_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Wed Jul 26 2000 - 10:26:19 CDT