Problems with DISCARDMAX in ORACLE SQL*Loader v. 1.1.9.0.1

From: Geir Engebakken <geir_at_fdmetd.uucp>
Date: 27 Aug 93 12:15:42 GMT
Message-ID: <995_at_fdmetd.uucp>


We have experienced that SQL*Loader v.1.1.9.0.1 does not load rows into tables if "discardmax=0" is used on the command line. The return code from SQL*Loader is 0 which indicates that everything has gone ok (Usual error return from Oracle utilities though :) ). But the log file says that 0 rows are loaded, and that maximum error count has been exceeded. If we remove discardmax=0 from the commandline it works ok and every row is loaded into the database.

We would like to specify discardmax=0 (according to the documentation 'all' is default), to insure that every row in the data-file has been loaded into the database. Has anyone got a workaround for this problem???

Thanks, Geir


                                Geir Engebakken
 _                              Fellesdata A.S
/__ o * }~                      P.O. Box 248
\_/_/\|_|                       0212 OSLO 2
                                NORWAY
Phone : +47 22 52 80 44          Fax   : +47 22 52 85 10
E-mail : ...!mcsun!nuug!fdmetd!geir  or           geir_at_fdmetd.uucp
<The opinions expressed, if any, do not represent Fellesdata a.s> Received on Fri Aug 27 1993 - 14:15:42 CEST

Original text of this message