Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alert log File (External tables)
MATHEW KING wrote:
>
> Hi Every one,
>
> I want to copy all the contents of An Oracle ALERT Log file in an
> Oracle table dynamically.
> Every time when I run the routine it append the text from alert log
> file into an Oracle table.
> Could someone give me suggestion how should it possible.
> Should I create and use external tables or procedure to do that.
>
> Any ideas will be appreciated.
>
> Regards
>
> M.King
You can find an implementation of this in one of the chapters of the book listed in my sig. It handles lengthy lines, associated the date/time stamp with each alert line, and anomalies like how ora-1555 is written to the log file in v9 etc
hth
connor
-- ------------------------------- Connor McDonald http://www.oracledba.co.uk Co-Author: "Mastering Oracle PL/SQL - Practical Solutions"Received on Tue Feb 17 2004 - 05:45:10 CST