Re: Create Rollback Question

Hi Andres!

From the statement, it could be observed that you are specifying MINEXTENTS of 20 and INITIAL of 100K, therefore the first extent would be 100K*10, i.e. 1000K. Your Optimial value should be greater than your first extent. Hope this helps you.

Thanks
Chandra

andres wrote:

> Hi everybody:
>
> I created a tablesegment using the following command:
>
> create tablespace rbs
> datafile '/fs4/oradata/prod/rbs01.dbf' size 100M
> minimum extent 500k
> default storage (initial 500K next 500K
> maxextents 500 pctincrease 0);
>
> Now I want to create a rollback segment using this other command:
>
> 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?
>
> Thanks and regards,
> andres
Received on Tue Nov 23 1999 - 12:04:03 CST