SQL Loader: Skip column

In the control file, you can specify a filler column so that it will be skipped.

SQL> desc dept
Name
-----------------
DEPTNO
DNAME
LOC

Control File

LOAD DATA
INFILE *
INTO TABLE dept
FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY '"'
(x filler integer, dname, loc)
BEGINDATA
12,RESEARCH,"SARATOGA"
10,"ACCOUNTING",CLEVELAND

It will allow you only load value for column dname and loc. The first column ID will be skipped.