Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Rollback
Shredder wrote:
> Sorry, Version 8i. >
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
![]() |
![]() |