Re: Alert log File (External tables)

"Joe" <nospam_at_joekaz.net> wrote in message news:b9c56449.0402180504.4bac273c_at_posting.google.com...
> "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?

Er, on a Windows platform where shell scripts are a bit thin on the ground, perhaps?

HJR Received on Wed Feb 18 2004 - 21:14:50 CST