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: Rollback

Re: Rollback

From: Mark Bole <makbo_at_pacbell.net>
Date: Wed, 30 Nov 2005 23:39:25 GMT
Message-ID: <NKqjf.24999$dO2.5565@newssvr29.news.prodigy.net>


Shredder wrote:

> Sorry, Version 8i.
> 

>>Shredder wrote:
>>
>>
>>>Is it the size of a tablespace that limits the rollback segment? I am
>>>trying to delete a large amount of data in a table and get an error that
>>>the rollback segment could not be created.
>>
>>Version of Oracle and exact error message are critical when you post
>>requests for help. For example, rollback segments are deprecated in favor
>>of automated undo management in currently supported versions of Oracle.
>>
>>Search http://asktom.oracle.com for more information on rollback segments
>>problems and how to avoid them. For example, try instead to create a new
>>table as select from the old table (CTAS) and then replace the old table,
>>rather than trying to delete directly from the old.
>>

Again, please post your exact error. It doesn't make sense to get an error about failure to create a rollback segment unless you are trying to create a rollback segment. More likely, you are getting an error about being unable to extend an existing rollback segment.

The size of the tablespace containing a rollback segment is an absolute limit on the size, since a segment cannot span more than one tablespace, but the unavailability of suitable extents to allocate to the segment could result in a lower limit. Rollback segments grow and shrink in a variety of ways, some automatic, some under your control. Assignment of a specific rollback segment to your transaction can also be either automatic or manual.

Did you check the AskTom site? If you are not the DBA, ask the DBA for assistance. If you are the DBA, you need to do some more reading in teh concepts manual, and plan to upgrade to a supported version of Oracle as soon as feasible.

-Mark Bole Received on Wed Nov 30 2005 - 17:39:25 CST

Original text of this message

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