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

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

From: Manuela Mueller <520040906697-0001_at_t-online.de>
Date: Mon, 12 Nov 2001 23:26:59 +0100
Message-ID: <3BF04CB3.81FF44CE@t-online.de>


DH wrote:
>
> 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

Hello DH,
this is a very common problem. Take a look at http://www.jlcomp.demon.co.uk/faq/snapshot.html there a two very interesting links for further reading. ...have a nice day
Manuela Mueller Received on Mon Nov 12 2001 - 16:26:59 CST

Original text of this message

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