Re: load with carriage return

HI,

have you tried to enclose the text with <CR> in " - use the loader option OPTIONALLY ENCLOSED BY '"' In works with LONG columns in my database (on NT).

laLocA

On Mon, 28 Jan 2002 17:48:52 GMT, j.w.vandijk_at_hetnet.nl (Jaap W. van Dijk) wrote:

>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 - 12:29:25 CST