Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Alert log File (External tables)
"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