Re: Create Rollback Question

Hi andres,

andres wrote:
> create rollback segment r01
> tablespace rbs
> storage ( initial 100K next 100K
> minextents 20
> maxextents 30
> optimal 100K );
>
> But all I got is an error saying this:
> ORA-01593: rollback segment optimal size (50 blks) is smaller than the
> computed
> initial size (1000 blks)
>
> Why it says that the computed initial size is 1000 blks if I defined as 100K
> and why it says that optimal is 50 blks when I am defining it as 100K?
>
> Could somebody, please, explain these gloomy things to me?

The initial size is:
minextents * extent size = 20 * 100K = 2000 K = 1000 * 2k (Block size).

You have a contradiction between you optimal size (100k) and your minimal size (2000 k)

Best regards!
--
uwe.schneider_at_xlink.net Received on Tue Nov 23 1999 - 10:38:16 CST