Re: SQL*Loader Question
Date: Tue, 20 Jun 2017 14:36:52 -0400
Message-ID: <CAFQ5ACJ+oxVJXNKeNZtKCw7_Wd+LjtUe7z=rraqGFe7PW+Y-BQ_at_mail.gmail.com>
What error do you see in the SQL*Loader log file for the rows that fail to load?
-Mark
On Tue, Jun 20, 2017 at 1:58 PM, Scott Canaan <srcdco_at_rit.edu> wrote:
> 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_at_rit.edu)
>
> (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
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Jun 20 2017 - 20:36:52 CEST