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

See my site. Tips. Administration. There's a paper on snapshot too old there.

A quick cure might be to perform your export with CONSISTENT=N. But that's dealing with the symptoms, not the cause. Read the paper and understand the cause.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"DH" <huyv_at_usa.net> wrote in message
news:ea21995c.0111121437.2d03487b_at_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