Re: load with carriage return

From: Titi <thierry.constant2_at_wanadoo.fr>
Date: Mon, 28 Jan 2002 21:27:21 +0100
Message-ID: <3c55b35e$0$16578$626a54ce@news.free.fr>

I found the solution:
change in the file CR -> |CR
and
infile ... "str X0c0a"

works for me

"Jaap W. van Dijk" <j.w.vandijk_at_hetnet.nl> a écrit dans le message de news: 3c558ec5.1192788_at_news.freeler.nl...
> There's a Note (doc id 1011372.6) on metalink with title
>
> "How to load a Carriage Return or Newline using SQL*Loader"
>
> Jaap.
>
> On Sat, 26 Jan 2002 09:55:39 +0100, "Thierry"
> <thierry.constant2_at_wanadoo.fr> wrote:
>
> >Hi,
> >
> >I have to load (with SQL*Loader) a text file with fields VARCHAR2
> >the text field has carriage return in it so the load failed ...
> >
> >How can I load this file ?????
> >
> >Thanks for your help
> >
> >conf: WNT 4.0 Oracle 8.1.6,7
> >
> >
>
Received on Mon Jan 28 2002 - 14:27:21 CST