SQL*Loader line breaks in fields CSV file

From: S. Anthony Sequeira <tony_at_sequeira.org.uk>
Date: Wed, 17 Mar 2010 13:46:46 -0000 (GMT)
Message-ID: <24af2ec0cf5e063e0fd61146a111c27e.squirrel_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 Received on Wed Mar 17 2010 - 08:46:46 CDT

This message: [ Message body ]
Next message: andrey khudyakov: "Re: SQL*Loader line breaks in fields CSV file"
Previous message: Goulet, Richard: "RE: Risk of RULE mode in 10g+"
Next in thread: andrey khudyakov: "Re: SQL*Loader line breaks in fields CSV file"
Reply: andrey khudyakov: "Re: SQL*Loader line breaks in fields CSV file"
Maybe reply: Tony Sequeira: "Re: SQL*Loader line breaks in fields CSV file"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message