Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: HELP ORA-01555 - snapshot too old.....

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

From: <schponk_at_Weurk>
Date: Thu, 27 Jun 2002 11:27:48 +0200
Message-ID: <afel6n$lam$1@reader1.imaginet.fr>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US