Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Transaction segmentation
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