Re: ALert Log File(External Table)

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Sun, 15 Feb 2004 20:45:30 +0100
Message-ID: <402fcbc9$0$28747$626a14ce@news.free.fr>

"Ron" <support_at_dbainfopower.com> a écrit dans le message de news:0ridneMuGr1gJ7Ld4p2dnA_at_comcast.com...
> Hello Daniel,
>
> Did you ever tried or review second example?
>
> It is clearly not working because of "FIELDS TERMINATED by ' '" -
> records are skipped and damaged all over.
>
> Regards,
>
> Ron
> DBA Infopower
> http://www.dbainfopower.com
> Standard disclaimer:
> http://www.dbainfopower.com/dbaip_advice_disclaimer.html
>

<snip>

It was just an example, feel free to correct it ;-)

btw, you're right 3 spaces are too few, you have to put more. Try 20 or 30, i think it might work:

FIELDS TERMINATED by '                        '

(must be greater than the number of spaces between a parameter name and the = sign)

Regards
Michel Cadot Received on Sun Feb 15 2004 - 13:45:30 CST