Re: Alert Log file(version 8i)

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Mon, 16 Feb 2004 10:00:48 +0100
Message-ID: <4030863c$0$13024$636a15ce@news.free.fr>

"MATHEW KING" <bzbzzb_at_hotmail.com> a écrit dans le message de news:528c8daf.0402152351.5fddb6eb_at_posting.google.com...
> Hi,
>
> Thanks all of you for the useful info.
> I would like to say that for reading alert log file, we are using
> external tables, which is the feature of 9i.
> But for 8i, what should we do in order to read the same alert log
> file.Because external table feature is not available in Version 8i
> Any suggestions will aslo be appreciated.
>
> Thanks
>
> M. King

There is no full SQL solution.
You can use sql*loader the same way to load a table with alert.log

A more complex solution is to use an external procedure that launches the sqlloader. I don't try it, it's just an idea.This is still not a full SQL solution.

Regards
Michel Cadot Received on Mon Feb 16 2004 - 03:00:48 CST