Thanks, I have seen those solutions however, he treats each line as a row
and then uses lag and lead to find the date. However, some entries are more
than a single line which is why that won't work for me.
<fitzjarrell_at_cox.net> wrote in message
news:1179262835.015225.3680_at_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:32:34 CDT
