Re: Rollback segments

if i were you, i would divide the transaction into several smaller transactions and commit once after each small transaction completes

thanks
uc

Kevin Gray <kevin.gray_at_andata.co.uk> 次寫入到主題 <01bdd753$6bccc040$7f517bc1_at_BASKET>...
>
> Hi there
>
> I am writing some SQL scripts with Unix shell as well to do some very
large
> updates (could be moving 3.5million records in insert/select
combination).
>
> Can anyone provide answers to the following.
>
> 1. Is it possible to have a single insert/select run without requiring a
> rollback segment to use?
> 2. Is it possible to use multiple rollback segments for a single
> insert/select transaction?
> 3. Is it possible to use multiple files in a single rollback segment so
> that the rollback segment can be split over several files and, possibly,
> disks?
>
> Also, does anyone know exactly the best way to work out how much space to
> allow for rollback segments.
>
> Any help would be very much appreciated.
>
> Thanks.
>
> Regards
>
> Kevin Gray
>
> Kevin Gray
> Senior Consultant
> The Customer Engagement Company, UK
> Email: kevin.gray_at_h2engage.co.uk
> WWW: http://www.h2engage.co.uk/
>
Received on Thu Sep 03 1998 - 23:08:16 CDT