Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP ORA-01555 - snapshot too old.....
Ok Thanks !
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> a écrit dans le message news:
uhjv474bendq89_at_corp.supernews.com...
>
> "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
>
>
>
Received on Thu Jun 27 2002 - 04:27:48 CDT
![]() |
![]() |