SQL*Loader
From: <dmurphy7_at_my-dejanews.com>
Date: Thu, 11 Jun 1998 22:03:04 GMT
Message-ID: <6lpk6n$ost$1_at_nnrp1.dejanews.com>
[Quoted] [Quoted] I am trying to load a file that contains many records of a tab delimited file [Quoted] that contains raw laboratory results. There is a specific structure to this [Quoted] 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.
Date: Thu, 11 Jun 1998 22:03:04 GMT
Message-ID: <6lpk6n$ost$1_at_nnrp1.dejanews.com>
[Quoted] [Quoted] I am trying to load a file that contains many records of a tab delimited file [Quoted] that contains raw laboratory results. There is a specific structure to this [Quoted] 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 [Quoted] 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:03:04 CEST