RE: SQL*Loader ignoring additional columns when delimited

Scott,

>this case, I would
>like SQL*Loader to treat the row as invalid and write it to
>it's "bad" file.

Since you are on 9.2, have you considered using External files to process the input and load it? This is a great ETL tool and saves much downstream processing. Examples for using External files are all over the internet and at the IOUG repository.

Hth,
John Kanagaraj <><
DB Soft Inc
Phone: 408-970-7002 (W)

http://tahiti.oracle.com - Manuals for DBAs (English only) http://www.bibleserver.com - Manual for Life (in English, Deutsch, French, Italian, Spanish, Portugese, Turkish,...)

• The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- http://www.freelists.org/webpage/oracle-l