Have you tried to run sqlldr with BAD data?

Yechiel Adar
Mehish
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, October 02, 2003 4:44 PM


>
> Please give me an example on this.
>
>
> Roland
>
>
>
>
>
>
>                       Jack van Zanen
>                       <[EMAIL PROTECTED]        To:       Multiple
recipients of list ORACLE-L <[EMAIL PROTECTED]>
>                       S.NL>                    cc:
>                       Sent by:                 Subject:  RE: logg error
line in unix
>                       [EMAIL PROTECTED]
>                       .com
>
>
>                       2003-10-02 15:54
>                       Please respond to
>                       ORACLE-L
>
>
>
>
>
>
> Bad records go to bad file
> Logfile can be turned on with log parameter
>
> Jacob A. van Zanen
> Oracle DBA
> Quant Systems Europe b.v.
> Tel : +31 (0) 251 - 268 268
> Mobile: +31 (0) 6 51308813
> Fax: +31 (0) 251 - 268 269
> E-mail: mailto:[EMAIL PROTECTED]
> Visit our web site at http://www.quantsystems.nl/
>
>
>
> -----Original Message-----
> Sent: Thursday, October 02, 2003 3:35 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Hallo again,
>
> I would like to get some help on this.
>  I have a script called let us say test.sh and that script runs an
sqlloader
> script, which loads semicolonseparated data into an oracle table. I would
> like to have an example on how to log an error when trying to insert the
> data intothe table. I want the error to be both the error message and also
> tell me which line that is wrong in the file.
>
> So both errormessage and also complete line which is the error line.
>
>
> Thanks in advance
>
>
> Roland
>
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author:
>   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: Jack van Zanen
>   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:
>   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: Yechiel Adar
  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).

Reply via email to