Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alert log File (External tables)
"Howard J. Rogers" <hjr_at_dizwell.com> wrote in message news:<402c7f6e$0$28871$afc38c87_at_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
Just curious why - Can you give some examples of where it's useful to
see the alert log from inside the database as opposed to a shell
script outside the database?
-- Joe http://www.cafeshops.com/joekaz http://www.joekaz.netReceived on Wed Feb 18 2004 - 07:04:53 CST