From: John Jones <john@iluvatar.tip.duke.edu>
Subject: Re: Carriage Returns and SQL*Loader
Date: 1995/06/06
Message-ID: <Pine.NXT.3.90.950606081210.1014A-100000@iluvatar>#1/1
references: <3qci7q$3ov@nz12.rz.uni-karlsruhe.de>
x-sender: john@iluvatar
content-type: TEXT/PLAIN; charset=US-ASCII
organization: Duke University, Durham, NC, USA
mime-version: 1.0
newsgroups: comp.databases.oracle


We had this same problem.  We were converting from FoxPro memo fields to 
oracle long fields.  What we did was in FoxPro we put a special character 
where the carriage return was, then we loaded into Oracle using sqlloader 
and then once in Oracle we used the replace function in Sql*Plus to 
replace the special character with a carriage return.

--------------------------------------------------------------------
John Jones			| my views are my own.........
Oracle Consultant		| no matter what company they are
john@iluvatar.tip.duke.edu	| coming from.
--------------------------------------------------------------------