Re: SQL Loader in one transaction
From: Mladen Gogala <mgogala_at_no.address.invalid>
Date: Mon, 20 Sep 2010 05:43:05 +0000 (UTC)
Message-ID: <i76s99$3rr$3_at_solani.org>
On Sun, 19 Sep 2010 15:27:25 +0200, bob123 wrote:
Date: Mon, 20 Sep 2010 05:43:05 +0000 (UTC)
Message-ID: <i76s99$3rr$3_at_solani.org>
On Sun, 19 Sep 2010 15:27:25 +0200, bob123 wrote:
> Hi,
>
> How can I do a load with SQL Loader
> in one transaction (i.e. all or nothing) rows parameter is too low for
> my data
>
> 10.2.0.4
>
> Thanks in advance
Make the file accessible as an external table and do "create as select". That would be a single transaction, succeeds or fails as a whole.
-- http://mgogala.byethost5.comReceived on Mon Sep 20 2010 - 00:43:05 CDT