Home » RDBMS Server » Server Utilities » Line break problem in sql loader
Line break problem in sql loader [message #254206] Thu, 26 July 2007 02:52 Go to next message
Messages: 1
Registered: July 2007
Junior Member
Hi people,

I'm inserting data into a table through sql loader using a csv file. The problem I'm having is when it comes to a field where the data has a line break, it'll insert it into a new row, or place the record into the bad file, but truncated.


messageid, message, messagetype

1, "Hello World", "text"
2, "This is a
message", "text"
3, "A message", "text"

In the bad file, it shows that the second one failed and appears as:

2, "This is a

Is there a way to fix this from happening without the need to change the csv files?
Re: Line break problem in sql loader [message #254225 is a reply to message #254206] Thu, 26 July 2007 03:46 Go to previous message
Michel Cadot
Messages: 63908
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
OracleŽ Database Utilities
Part II SQL*Loader
Chapter 8 SQL*Loader Control File Reference
Section Assembling Logical Records from Physical Records

Previous Topic: SQL*Loader-704
Next Topic: export Fail - only answer this if you're a lazy arrogant SOB like me
Goto Forum:

Current Time: Fri Oct 21 06:34:06 CDT 2016

Total time taken to generate the page: 0.14714 seconds