| SQL*Loader: problem with carriage returns [message #72739] |
Fri, 10 October 2003 09:19 |
Wim Dokter
Messages: 1
Registered: October 2003
|
Junior Member |
|
|
I'm trying to load an MSAccess table into an Oracle table by exporting it to a flat file and then loading it with SQL*Loader. Problem: the table has several memo fields containing multiple text lines with (invisible) carriage returns; SQL*Loader misinterprets these returns as end of line characters. In Oracle I defined one LONG column and several varchar2(2000) ones to receive this data.
My ctl file looks like this:
options ()
load data
infile '/path/textfile.dat'
truncate into table patient
fields terminated by '|'
trailing nullcols
(
PatientID integer external,
Datum date,
Reason char(2000) enclosed by '"',
... etc.
)
I keep getting the error
" ... second enclosure string not present " if e.g. the field Reason contains a Return.
The flat file (ftp-ed to Unix) shows no symbols. In vi the cursor jumps to the next line at every Return, midfield or end of record. Please help:
- Should I use a powerful Text Editor like Textpad to adjust the textfile? How?
- Add something like "str '|'" to INFILE? What should the textfile be like in this case?
- save file as ANSI code or something else?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
