Re: SQL*Loader line breaks in fields CSV file
- From: "Tony Sequeira" <tony@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- 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.
Regards.
On Wed, March 17, 2010 13:58, andrey khudyakov wrote:
> http://www.orafaq.com/wiki/SQL*Loader_FAQ#How_does_one_load_records_with_multi-line_fields.3F
> <http://www.orafaq.com/wiki/SQL*Loader_FAQ#How_does_one_load_records_with_multi-line_fields.3F>
>
> 2010/3/17 S. Anthony Sequeira <tony@xxxxxxxxxxxxxxx>
>
>> Hi,
>>
>> 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
>> breaks.
>> This causes SQL*Loader to throw a fit.
>>
>> I believe that I will have to manipulate the datafile, to remove the
>> line
>> breaks, I'm hoping that someone somewhere has found a better way.
>>
>> Regards.
--
Tony
--
//www.freelists.org/webpage/oracle-l
Other related posts:
