Re: ALert Log File(External Table)

Yep, or just use "DUMMY_XXX" or some other non-sense as terminator ;-)

Regards,

  Ron
  DBA Infopower
  http://www.dbainfopower.com
  Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html

"Michel Cadot" <micadot{at}altern{dot}org> wrote in message news:402fcbc9$0$28747$626a14ce_at_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:51:55 CST