oracle@mutation#cat file.ctl
LOAD DATA
infile 'file.dat'
replace INTO TABLE one
FIELDS TERMINATED BY "," optionally enclosed by '"' trailing nullcols
(
c1,
c2,
dummycol3 filler,
c3,
dummycol5 filler,
c4,
c5
)
into table two
replace
FIELDS TERMINATED BY "," optionally enclosed by '"' trailing nullcols
(
c1 POSITION(1),
c2 POSITION(5)
)


oracle@mutation#cat file.dat
123,456,789,100,111,222,333
123,456,444,555,666,777,888
123,456,555,555,567,678,789
123,234,345,456,567,678,789
987,876,765,654,543,432,321
987,876,123,234,345,456,567


oracle@mutation#sqlldr userid=scott/tiger control=file.ctl

SQL*Loader: Release 9.2.0.4.0 - Production on Tue Jun 20 13:38:38 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Commit point reached - logical record count 6

oracle@mutation#query mutation scott.one

        C1         C2         C3         C4         C5
---------- ---------- ---------- ---------- ----------
       123        456        100        222        333
       123        456        555        777        888
       123        456        555        678        789
       123        234        456        678        789
       987        876        654        432        321
       987        876        234        456        567

6 rows selected.

oracle@mutation#query mutation scott.two

        C1         C2
---------- ----------
       123        456
       123        456
       123        456
       123        234
       987        876
       987        876

6 rows selected.