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

On Fri, 21 Feb 2003 00:50:20 +0000, krishna wrote:

> 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

If you have a dba at your site pass on the error message to the DBA . Received on Fri Feb 21 2003 - 06:35:00 CST