Re: ORA-01555: snapshot too old: rollback segment number 2 with name "R01" too small

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-01555: snapshot too old: rollback segment number 2 with name "R01" too small

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 21 Feb 2003 07:15:17 -0800
Message-ID: <a20d28ee.0302210715.66f2f77@posting.google.com>

s_venkatakrishna_at_hotmail.com (krishna) wrote in message news:<8cdd702b.0302210050.6bc02abd_at_posting.google.com>...
> Guys,
>
> I am getting the above when I am importing from
> a view. I have a .sql file running through unix shell script.
>
> I Understand that I have to increase the ROLLBACK Segment size.
> Where should I do this / run this from ? In my script? or has to be
> done at DBA level?
>
> Please help me.
>
> Cheers,
> krish

at DBA level.

alter rollback segment offline
drop rollback segment
create rollback segment

Regards
Sybrand Bakker
Senior Oracle DBA Received on Fri Feb 21 2003 - 09:15:17 CST