Re: SQL*Loader line breaks in fields CSV file
Date: Wed, 17 Mar 2010 14:44:40 -0000 (GMT)
Hi Andrey and list,
Having found some time to read this, I don't believe it will work for my current circumstances, without manipulating the datafile.
Each datafile line is terminated by a newline. Within each line, there are several fields, some of which may have embedded newlines.
An example follows:
1,"A',"ORACLE-L is a good resource, sometimes",100,, 2,"B","MOS has been superseded by Google, most of the time",110,5,"Z"
Note the last 2 lines, should be treated as one by SQL*Loader.
On Wed, March 17, 2010 13:58, andrey khudyakov wrote:
> 2010/3/17 S. Anthony Sequeira <tony_at_sequeira.org.uk>
>> I'm working on migrating large amounts of data from a DB2 database to an
>> Oracle 10g database (10.2.0.1) Windows. Will eventually reside in an
>> 11gR2 database (not sure about OS yes, I don't make the decision).
>> I've having issues with descriptive text fields that contain line
>> This causes SQL*Loader to throw a fit.
>> I believe that I will have to manipulate the datafile, to remove the
>> breaks, I'm hoping that someone somewhere has found a better way.
-- Tony -- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 17 2010 - 09:44:40 CDT