Re: SQL*Loader line breaks in fields CSV file
From: andrey khudyakov <andrey.hudyakov_at_gmail.com>
Date: Wed, 17 Mar 2010 15:58:13 +0200
Message-ID: <ef6564031003170658l67586e93h2d6ac5c65caf3b2c_at_mail.gmail.com>
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>
Date: Wed, 17 Mar 2010 15:58:13 +0200
Message-ID: <ef6564031003170658l67586e93h2d6ac5c65caf3b2c_at_mail.gmail.com>
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_at_sequeira.org.uk>
> 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
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Mar 17 2010 - 08:58:13 CDT