On Tue, 15 May 2007 17:32:34 -0400, Scott wrote:
> 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
>>
There is always Perl which can be (ab)used to slice and dice the
log in an interesting ways, and also to load it into the database.
--
http://www.mladen-gogala.com
Received on Tue May 15 2007 - 22:58:05 CDT
