Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader Question
Hi,
I get a comma separated file containing thousands of records. Each row
contains 29 columns. I need to
load the data into a table, but I need only 11 of the 20 columns i.e.
the table has only 11 columns. The
columns to skip are distributed across the entire row. If they were at
the end of the row, then the
columns get skipped automatically. But, how do I tell SQL*Loader to
ignore columns via the control
file?
My current control file looks like this (all the fields called "dummy"
are the ones that I want to ignore).
It obviously doesn't work, because the dummy columns are not in the
table.
Thanks,
regards,
VJ.
load data
infile '/tmp/people.list'
replace
into table buf_people
fields terminated by ','
(unique_key,
dummy1,
record_type,
status,
emp_role,
dummy2, dummy3, dummy4,
dummy5, dummy6, dummy7, dummy8,
dummy10, dummy12, dummy13, dummy14,
--
Vijay Damodaran
vijayd_at_nortel.com
Work: (972) 685-8150
--
Received on Tue Sep 22 1998 - 00:00:00 CDT