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>


I'm working on migrating large amounts of data from a DB2 database to an Oracle 10g database ( 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.




http://www.freelists.org/webpage/oracle-l Received on Wed Mar 17 2010 - 08:46:46 CDT

Original text of this message