Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> ORA-01555: snapshot too old (rollback segment too small)
I am getting occasional ORA-01555 errors. It has happened when I insert data
or create tables.
My rollback segments were created as below. (I originally had only 4 but
added more in an attempt to solve this issue.)
create tablespace rbs datafile
'/ora05/app/oracle/product/8.1.5/database/rbs01.dbf' size 15M reuse
default storage (
initial 512k
next 512k
pctincrease 0
minextents 2
maxextents unlimited
);
alter tablespace rbs add datafile
'/ora05/app/oracle/product/8.1.5/database/rbs02.dat' size 15M autoextend on;
create rollback segment r01 tablespace rbs storage( optimal 2200K ); create rollback segment r02 tablespace rbs storage( optimal 2200K ); create rollback segment r03 tablespace rbs storage(optimal 2200K ); create rollback segment r04 tablespace rbs storage( optimal 2200K ); create rollback segment r05 tablespace rbs storage( optimal 2200K ); create rollback segment r06 tablespace rbs storage( optimal 2200K ); create rollback segment r07 tablespace rbs storage( optimal 2200K ); alter rollback segment r01 online; alter rollback segment r02 online; alter rollback segment r03 online; alter rollback segment r04 online; alter rollback segment r05 online;