You can use the FILLER,

LOAD DATA
INFILE *
APPEND INTO TABLE my_table
FIELDS TERMINATED BY ','
(field1,
field2 FILLER,
field3)
BEGIN DATA
A,B,C









Ruel Rodriguez
Global Computer Associates
Richmond, Virginia

----- Original Message -----
From: Puneet Sharma
To: LazyDBA.com Discussion
Sent: Friday, January 31, 2003 10:24 AM
Subject: Problem with SQl loader


Hi All,

I want to load data in a table except one column with SQL Loader. Is it possible and if yes then what should be the value in control file for this?

Thanks,
Puneet
Oracle LazyDBA home page