Re: SQL Loader in one transaction
From: Mladen Gogala <mgogala_at_no.address.invalid>
Date: Mon, 20 Sep 2010 21:04:52 +0000 (UTC)
Message-ID: <i78i9k$sho$26_at_solani.org>
On Mon, 20 Sep 2010 06:07:53 -0700, Mark D Powell wrote:
Date: Mon, 20 Sep 2010 21:04:52 +0000 (UTC)
Message-ID: <i78i9k$sho$26_at_solani.org>
On Mon, 20 Sep 2010 06:07:53 -0700, Mark D Powell wrote:
> I think what you want to do is set errors=0
I don't think so. If several batches are committed when an error occurs, the file will be partially loaded, precisely what the OP doesn't want to happen. One way of accomplishing the task at hand is by using an external table, another one is by writing a custom load procedure in some scripting language. SQL*Loader is not the right tool in this case.
-- http://mgogala.byethost5.comReceived on Mon Sep 20 2010 - 16:04:52 CDT