Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> CREATE ROLLBACK SEGMENT

CREATE ROLLBACK SEGMENT

From: <diegolosi_at_my-deja.com>
Date: Thu, 16 Nov 2000 12:40:54 GMT
Message-ID: <8v0kkm$6hl$1@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. Received on Thu Nov 16 2000 - 06:40:54 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US