Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Transaction segmentation

Re: Transaction segmentation

From: Michael Bierenfeld <michael.bierenfeld_at_ibs-ag.de>
Date: Thu, 06 May 1999 17:26:40 +0000
Message-ID: <3731D0D0.687FF6A@ibs-ag.de>


Khemraj DOOKHEE wrote:
>
> Hi everyone,
>
> I would like to segment a big Oracle transaction (such as an insert of a
> million records into a table) into smaller ones.
>
> I tried to execute my big transaction, but it failed due to a rollback
> segment error. I do not want to alter any rollback segments, so I
> suppose the only solution left to me is to try to cut the transaction
> into smaller ones and then execute them one after the other.
>
> The problem is that I do not know how to perform such an operation, that
> is to segment a transaction into several smaller ones.
>
> By the way, I've got another question. How can we affect a reasonable
> value for the INITIAL parameter of a rollback segment ? Is it by trial
> and error ?
>
> Any help would be much appreciated.
>
> Thanks,
>
> Khemraj.

Hello,

this strongly depends on the type of your transactions. Millions of rows ? Are they comming from a different table or a text-file or whatever.

There are several possibilities :

Could you send an example of those transactions.

Regards

Michael Received on Thu May 06 1999 - 12:26:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US