Re: CREATE ROLLBACK SEGMENT

First off, if you have a block size of 8K it's a bit daft to be expecting to get an extent of 10K. You can expect that statement immediately to be rounded up, so that you would end up with 16K extents. That gets you half way to the 640K Oracle clearly thinks the thing should be -and immediately makes the initial size bigger than your optimal (which is just a mathematical calculation, not a physical one).

As for the rest? Lord knows. What are your tablespace settings?

Regards
HJR

--
---------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
---------------------------------------------------------------------------


<diegolosi_at_my-deja.com> wrote in message news:8v0kkm$6hl$1_at_nnrp1.deja.com...


> I am using Oracle Version 8.1.5 on an NT server

> I have this problem:

> I want to create a rollback segment,

>

> create public rollback segment RB2

> tablespace RBS

> storage (

> initial 10 K next 10 K optimal 300 K

> minextents 20 maxextents 450);

>

> ORA-01593: rollback segment optimal size (38 blks) is smaller than the

> computed initial size (80 blks)

>

> The db_block_size is 8192. Is the initial size of the rollback segment

> 200K?

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.