RE: SQL*Loader ignoring additional columns when delimited
- From: John Kanagaraj <john.kanagaraj@xxxxxxx>
- To: "'scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx'" <scott.hutchinson@xxxxxxxxxxxxxxxxxxxxx>, oracle-l@xxxxxxxxxxxxx
- Date: Tue, 1 Mar 2005 08:49:56 -0800
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
Other related posts: