Re: SQL*Loader question

Run your file through sed or awk to delete the field and adjust the loader control info.

or

load the data into a junk table, then insert the data into the real table without the date field.

Christopher B. Loggans (cloggans_at_nova.umuc.edu) wrote:
: Besides using positional field specifications in the control file, does
: anyone know of a way to skip a column of data from the input data file
: that you do not want loaded into the database? (For example, you deleted
: a column from a table and want to re-load it from the original flat file
: which still contains values for the deleted column.)
 

: Thanks,
: -Chris

--
This posting represents the personal opinions of the author. It is not the
official opinion or policy of the author's employer. Warranty expired when you
opened this article and I will not be responsible for its contents or use.