Ken, Good to know that it worked. Not sure what books you referred to, but if you deal with SQL*Loader a lot, then you may want to check out Jonathan Gennick's book titled 'Oracle SQL*Loader : The Definitive Guide' by O'Reilly.
Regards. - Kirti -----Original Message----- Sent: Wednesday, December 19, 2001 7:20 AM To: Multiple recipients of list ORACLE-L Kirti: Another person recommended this approach and it worked very nicely. To bad it's not in the book. Thanks much, Ken -----Original Message----- Sent: Tuesday, December 18, 2001 10:20 PM To: Multiple recipients of list ORACLE-L Subject: RE: SQL Loader Load Problem Ken, If you are using 8i, then you can use the 'filler' fields. In this case the control file would look something like below(considering the fields are terminated by a comma and the table has columns a, b and c) load data infile 'myfile' into table mytable fields terminated by ',' (a char, b char, f3 filler char, f4 filler char, f5 filler char, f6 filler char, .... f42 filler char, c char ) If you are not using 8i, then you can not avoid an intermediate table, or use OS level tools to chop off the unwanted fields. HTH, - Kirti -----Original Message----- Sent: Tuesday, December 18, 2001 4:15 PM To: Multiple recipients of list ORACLE-L I have an input file that is delimited and contains 43 fields of various widths. I need to load only 3 fields into a DB table of 3 columns. 2 of the fields are at the beginning of the record and 1 is the very last field in the record. How can I load only these 3 cols and ignore the other 40 cols I don't need without having to use an intermediate table? Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).