RE: SQL Loader Load Problem
That's the book I have. I have not found any other books totally for SQL*Loader. Ken -Original Message- Sent: Wednesday, December 19, 2001 8:16 AM To: Multiple recipients of list ORACLE-L Subject: RE: SQL Loader Load Problem 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). -- 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).
RE: SQL Loader Load Problem
- Original Message - To: <[EMAIL PROTECTED]> Sent: Wednesday, December 19, 2001 11:30 AM > With Oracle 7.3.4 you could use this method: > > LOAD DATA > INFILE 'example.dat' > BADFILE 'example.bad' > insert > INTO TABLE emp > FIELDS TERMINATED BY ';' > (empno POSITION(*), > ename POSITION(*), > job POSITION(*+2), > mgr POSITION(*)) > > Here are the contents of data file example.dat > > 7782;CLARK;;;MANAGER;7839 > > > 125;Peter;;;258; > - Original Message - > From: Ken Janusz <[EMAIL PROTECTED]> > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Tuesday, December 18, 2001 7:15 PM > Subject: SQL Loader Load Problem > > > > 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] > > > > 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: Paula Wachtmeister 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).
RE: SQL Loader Load Problem
page 121 'skipping fields you don't want to load' of g.gennick 'oracle sql*loader' book. -Original Message- Sent: Wednesday, December 19, 2001 9:16 AM To: Multiple recipients of list ORACLE-L 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
RE: SQL Loader Load Problem
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).
RE: SQL Loader Load Problem
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).
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).
SQL Loader Load Problem
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] 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).
SQL Loader Load Problem
I have a data file of 11 fields to load into a table of 8 columns. I only have to load 3 of the input fields. How do I handle the extra input fields? I cannot use the DB table column for filler more than once. Can I just ignore the input fields I don't have to load? I am using "trailing nulls" and options direct=true. 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] 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).