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/your_password_at_your_hostname 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 <john.dunn_at_sefas.co.uk> 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: john.dunn_at_sefas.co.uk
> >
>
> __________________________________
> 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: kirtikumar_deshpande_at_yahoo.com
>
> 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: ListGuru_at_fatcity.com (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).
Received on Thu Jul 17 2003 - 08:47:14 CDT