Re: SQL Loader in one transaction
From: Mark D Powell <Mark.Powell2_at_hp.com>
Date: Mon, 20 Sep 2010 06:07:53 -0700 (PDT)
Message-ID: <41f9be2f-1150-4ed5-94ae-6481f909591e_at_l17g2000vbf.googlegroups.com>
On Sep 19, 9:27 am, "bob123" <bob..._at_gmail.com> 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
Date: Mon, 20 Sep 2010 06:07:53 -0700 (PDT)
Message-ID: <41f9be2f-1150-4ed5-94ae-6481f909591e_at_l17g2000vbf.googlegroups.com>
On Sep 19, 9:27 am, "bob123" <bob..._at_gmail.com> 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
I think what you want to do is set errors=0
From 10gR2 Utilities Manual >>
ERRORS specifies the maximum number of insert errors to allow. If the
number of errors exceeds the value specified for ERRORS, then
SQL*Loader terminates the load. To permit no errors at all, set
ERRORS=0. To specify that all errors be allowed, use a very high
number. <<
HTH -- Mark D Powell -- Received on Mon Sep 20 2010 - 08:07:53 CDT