Re: About Rollback Segments

From: Extel Inc. <extel_at_shore.net>
Date: 1997/11/29
Message-ID: <65q1ab$7mv@shell2.shore.net>#1/1

Philip Fielder <phil.fielder_at_mci.com> writes:

>Jorge A. San Martn wrote:

>> Hi,
>> I have a lot of doubts about rollback segments (RS), I work with
>> Oracle Server 7.3.2.3, we have a table with a lot of records; 1,000,000
>> daily aprox, which must be deleted, but the rollback segments excedes
>> the MAXEXTENTS parameter. I have read the manual about RS, but I don't
>> know what values are the bests for a RS for this task. Is there a way
>> to disable the RS ?
>>

It may be obvious, and may already have been answered, but why is it necessary to do a million row delete inside a single transaction?! Received on Sat Nov 29 1997 - 00:00:00 CST