I am trying to load a CSV file into Oracle 12.1.0.2 using SQL*loader. I've
never run into an issue like the one I'm having now. The fields are all
variable length and comma-delimited. If the field has commas in it, then it is
enclosed in quotes. All looks good. In the CTL file, I start with:
load data
infile 'Advance2015.05_2017.csv'
badfile 'Advance2015.bad'
replace
into table advance.rit_matching_policy_2015
fields terminated by ',' optionally enclosed by '"'
trailing nullcols
Then list the columns. Near the end is a very long column (comment1) which is
defined as varchar2(3000) in the database. SQL*Loader will load all of the
rows fine, except those that have quotes around the comment1 field. I can't
figure out how to get it to load those rows and why it's having trouble with
the quotes ("). I'm sure it's something really simple, but I just can't see it.
Thank you,
Scott Canaan '88 (srcdco@xxxxxxx<mailto:srcdco@xxxxxxx>)
(585) 475-7886 - work (585) 339-8659 - cell
"Life is like a sewer, what you get out of it depends on what you put into it."
- Tom Lehrer