Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Alert log File (External tables)

Re: Alert log File (External tables)

From: Connor McDonald <hamcdc_at_yahoo.co.uk>
Date: Tue, 17 Feb 2004 19:45:10 +0800
Message-ID: <4031FEC6.1B5@yahoo.co.uk>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US