Re: SQL*Loader

Try to load your data in a temporary table and then count the records when equal run a script to transfer data to the original table.

Mars

vi.logistiek_at_wxs.nl

dmurphy7_at_my-dejanews.com wrote in message <6lpk6n$ost$1_at_nnrp1.dejanews.com>...
>I am trying to load a file that contains many records of a tab delimited
 file
>that contains raw laboratory results. There is a specific structure to
 this
>file. I have SQL*Loader working properly, however, I would like to ONLY
>commit all records if no errors are found. In other words, if there is a
>problem with any of the records, the whole file (and all of its records)
>should not be loaded.
>
>I have played with the ERRORS and DISCARDMAX parameters and they seem to
 stop
>the execution of the load, but do not "rollback" any records that were read
>above it.
>
>Can anyone lend a hand?
>
>Dan Murphy
>dmurphy_at_hiv.hjf.org
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Fri Jun 12 1998 - 00:00:00 CEST