Re: Why MINEXTENT value should be greater than 1 for rollback segment?

The rollback segment extents are used in a cyclic fashion. Once a rollback segment needs to extend beyond it's currrent extent, it will never put the 'head' pointer back into the same extent as the 'tail' pointer. Hence - as a minimum - two extents are required to 'form a circle' of extents.

OK, that's a brief simplification, but you really need to understand a lot more about how RBS work. Check the Backup and Recovery Handbook (Oracle Press) and the Oracle 'concepts' manual that ship with the product, they'll give you a good start.

Steve Phelan.

manoj67_at_hotmail.com wrote in message <6fpigh$ie2$1_at_nnrp1.dejanews.com>...
>I am trying to understand why the Minimum Number of
>Extents for a Rollback Segments should be more than
>1. When you create a rollback segment Oracle
>returns error. I want to know the logic behind it.
>
>Does anyone know the answer?
>
>Manoj
>
>-----== Posted via Deja News, The Leader in Internet Discussion ==-----
>http://www.dejanews.com/ Now offering spam-free web-based newsreading
Received on Tue Mar 31 1998 - 00:00:00 CST