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 -> ORA-01555: snapshot too old: rollback segment number 7 with name "RBS6" too small

ORA-01555: snapshot too old: rollback segment number 7 with name "RBS6" too small

From: DH <huyv_at_usa.net>
Date: 12 Nov 2001 14:37:35 -0800
Message-ID: <ea21995c.0111121437.2d03487b@posting.google.com>


Hi all,

My Rollback tablespace (Oracle 8.1.7) were created with parameters:

CREATE TABLESPACE RBS DATAFILE
'${ORA04}/oradata/${ORACLE_SID}/rbs01.dbf' SIZE 5 16M REUSE
 AUTOEXTEND ON NEXT 5120K
MINIMUM EXTENT 512K
DEFAULT STORAGE ( INITIAL 512K NEXT 512K MINEXTENTS 8 MAXEXTENTS 4096);

Now the database grows up and the rollback segment not big enough when running the full export of database. It stops always with the error messages below:

EXP-00008: ORACLE error 1555 encountered ORA-01555: snapshot too old: rollback segment number 7 with name "RBS6" too small
EXP-00000: Export terminated unsuccessfully

Does someone see this problem before?

Thanks in advance for any help.

DH Received on Mon Nov 12 2001 - 16:37:35 CST

Original text of this message

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