Rollback segments

From: Kevin Gray <kevin.gray_at_andata.co.uk>
Date: 3 Sep 98 15:50:23 GMT
Message-ID: <01bdd753$6bccc040$7f517bc1@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.

Is it possible to have a single insert/select run without requiring a rollback segment to use?
Is it possible to use multiple rollback segments for a single insert/select transaction?
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 - 10:50:23 CDT