Re: Load alert log into a table with sqlldr

From: <fitzjarrell_at_cox.net>
Date: 15 May 2007 14:00:35 -0700
Message-ID: <1179262835.015225.3680@p77g2000hsh.googlegroups.com>

On May 15, 3:53 pm, "Scott" <nos..._at_nomail.com> wrote:
> Using a 10.2 version of sqlldr does someone know of a way to load an alert
> log into a table?
>
> For example if my table has the definition
>
> log_entry_dt date
> log_entry varchar2(4000)
>
> how can I setup a control file to load the alert log into the database
> table?
>
> looking at the various ulcase files didn't provide any ideas of how I could
> potentially do this.
>
> thanks,
> scott

Tom Kyte explains how to make the alert log an external table. Visit asktom.oracle.com and search for alert log.

David Fitzjarrell Received on Tue May 15 2007 - 16:00:35 CDT