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
adun50
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.

eg

fields:
messageid, message, messagetype

data:
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: 64103
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

Regards
Michel
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: Sat Dec 03 18:08:55 CST 2016

Total time taken to generate the page: 0.08464 seconds