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: Howard J. Rogers <hjr_at_dizwell.com>
Date: Fri, 13 Feb 2004 18:40:20 +1100
Message-ID: <402c7f6e$0$28871$afc38c87@news.optusnet.com.au>

"MATHEW KING" <bzbzzb_at_hotmail.com> wrote in message news:528c8daf.0402122337.7c05f264_at_posting.google.com...
> 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

An External Table is exactly the way to go on this one (at least, it's something I set up in every database I work on). The benefits of being able to see the alert log from within the database itself by simple select statements is worth it in my book.

Regards
HJR

-- 
--------------------------------------------
Oracle Insights: www.dizwell.com
--------------------------------------------
Received on Fri Feb 13 2004 - 01:40:20 CST

Original text of this message

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