sqlldr questions
I'm a sqlldr newbie. Platform is Oracle 9.2. My question is...can I prevent sqlldr loading any data if there is even a single bad record, even if it is, for example, the last record? I am using conventional path load. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: sqlldr questions
An excellent book for SQL Loader new comers, and experienced users as well, is one by Jonathan Gennick and Sanjay Mishra : Oracle SQL Loader, The definitive Guide, by O'Reilly. Stenphen Andert will agree with me ;) - Kirti --- John Dunn [EMAIL PROTECTED] wrote: I'm a sqlldr newbie. Platform is Oracle 9.2. My question is...can I prevent sqlldr loading any data if there is even a single bad record, even if it is, for example, the last record? I am using conventional path load. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: Re: sqlldr questions
i read this last year. correct me if im wrong, but it didnt seem to have much more than was on otn? just explained slightly differently with a slightly more depth. From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2003/07/17 Thu AM 09:54:29 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: sqlldr questions An excellent book for SQL Loader new comers, and experienced users as well, is one by Jonathan Gennick and Sanjay Mishra : Oracle SQL Loader, The definitive Guide, by O'Reilly. Stenphen Andert will agree with me ;) - Kirti --- John Dunn [EMAIL PROTECTED] wrote: I'm a sqlldr newbie. Platform is Oracle 9.2. My question is...can I prevent sqlldr loading any data if there is even a single bad record, even if it is, for example, the last record? I am using conventional path load. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: sqlldr questions
Please look the following text, which works fine everyday for loading my data into oracle 9.2 database. $ORACLE_HOME/bin/sqlldr USERID=your_username/[EMAIL PROTECTED] control=link-summary.ctl log=link-summary.log $ more link-summary.ctl options (rows=9297500, errors=2, bindsize=100, readsize=100) LOAD DATA INFILE '/tmp/log_file_parsing_output.dat' truncate INTO TABLE access_summary FIELDS TERMINATED BY ' ' (CLIENT_IP char(100), ACCESS_DATE char(9), URL char(400)) This is my application. You need to change file name, file path, and table name and its column name as well. Hope it can help you. Don Kirtikumar Deshpande wrote: An excellent book for SQL Loader new comers, and experienced users as well, is one by Jonathan Gennick and Sanjay Mishra : Oracle SQL Loader, The definitive Guide, by O'Reilly. Stenphen Andert will agree with me ;) - Kirti --- John Dunn [EMAIL PROTECTED] wrote: I'm a sqlldr newbie. Platform is Oracle 9.2. My question is...can I prevent sqlldr loading any data if there is even a single bad record, even if it is, for example, the last record? I am using conventional path load. John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn INET: [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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.net -- Author: Don Yu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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).
