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=20000, bindsize=1000000, readsize=1000000) 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).
