Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> CREATE ROLLBACK SEGMENT
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