Deleting alertlog while intance is running.

Is it possible to delete the alertlog file on a sparcstaion running solaris and oracle 7.3 while the instance is running?

What I what to do is to have a program copying the alertlog to another file, scanning the file for errors and deleting the original alertlog file (before it grows too large!) and hopefully the the instance starts producing a new alertlog file........

For this to work, it requires that the instance closes the alertlog each time it has written to the log. If the instance keeps the file open as long as it is running, the only thing you achieve by "deleting" the alertlog file while the instance is running is deleting the link to the file. In other words the file would continue to grow, but is no longer possible to access the the alertlog.

AM I WRONG?????????
(I wish I was!)

Yours Tor Kristjan Berge Received on Fri May 29 1998 - 04:26:40 CDT