Re: CREATE ROLLBACK SEGMENT

Thanks for your help, but it doesn't work: The PCTINCREASE of the tablespace was already set to 0, and if you consider PCTINCREASE = 50 the sum of the byte of 20 extents is more then 640K!!

Thanks in advance

   Diego

In article <8v0sis$cuq$1_at_nnrp1.deja.com>,   David Fitzjarrell <oratune_at_aol.com> wrote:
> In our last gripping episode diegolosi_at_my-deja.com wrote:
> > 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.
> >
>
> It depends upon the PCTINCREASE parameter of the RBS tablespace. If
> the PCTINCREASE is set to 0 (which it should be) then the initial size
> of the rollback segment would be 200K. However that is not the case
> since ORACLE is calculating that 20 extents will consume 80 8K blocks
> or 640K. I would think that your PCTINCREASE is set at the default
 for
> the tablespace, which is 50. Alter the PCTINCREASE value for the RBS
> tablespace:
>
> ALTER TABLESPACE RBS
> DEFAULT STORAGE(PCTINCREASE 0);
>
> and then create your rollback segment.
>
> --
> David Fitzjarrell
> Oracle Certified DBA
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 16 2000 - 10:47:37 CST