Re: HELP ORA-01555 - snapshot too old.....

"schponk_at_Weurk" <schponk_at_wanadoo.fr> wrote in message news:afcn2j$c09$1_at_reader1.imaginet.fr...
> OK, I understand... nearly...
> Thanks for your help...
>
> But....
> if I commit out of the llop, i'll be more data than my rollback can handle
> .... !
> of did i missed somethig ???
>
> Thanks again !
>
>
> > Please always research the archives.
> yes, it's true !
> but i still got questions !!!!
>
> ;oD !
>
>

The rollback segment, provided it is properly configured, will extent itself automatically. If you think it is too big after the deed you can always shrink it.
(alter rollback segment shrink to ... M)

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address