use FILLER aside of the column You want to discard.

example:

LOAD DATA INFILE 'x.dat'
REPLACE INTO TABLE x
FIELDS TERMINATED BY "|"
TRAILING NULLCOLS
(
Id,
Code2,
Code3 FILLER, <=== see here
ANumber
)


Regis

-----Original Message-----
From: Puneet Sharma [mailto:[Email Address Removed] Friday, January 31, 2003 3:24 PM
To: LazyDBA.com Discussion
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
*********************************************************************
This electronic transmission is strictly confidential and intended solely
for the addressee. It may contain information which is covered by legal,
professional or other privilege. If you are not the intended addressee,
you must not disclose, copy or take any action in reliance of this
transmission. If you have received this transmission in error,
please notify the sender as soon as possible.

This footnote also confirms that this message has been swept
for computer viruses.
**********************************************************************

Oracle LazyDBA home page