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 ** -- //www.freelists.org/webpage/oracle-l