I hope you meant that the other way around. Either way this not what Knut
actually said, he merely offered an explanation of why selects can read from
rollback segments - which does answer the question. The *right* answer is
surely to increase the size of your rollback segments (and check the access
plan of the query).
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"Epicentre Team B Annecy" <carmanet_at_epicentre.fr> wrote in message
news:aa6ite$cb3$1_at_wanadoo.fr...
> Hello Renato,
>
> Knut is right, so there are 2 ways to control this error, a good and a
> ''bad'' one:
>
> - the good way: executing large queries where your system is low on
> activity; by this way,
> extents in your rollback segments will not be erased by other data.
> - the bad way: increasing your rollback segments. This is a quite bad
> way, as it will not solve
> your problem, but only delay it!
>
> HTH to solve the pb.
>
> Regards,
>
> Celine.
>
> --
> Celine Armanet
> EPICENTRE
> carmanet_at_epicentre.fr
> Tel. : +33 04 50 09 7000
> "Renato" <rsimonetto.bis_at_NONFARMISPAMreplay.it> a écrit dans le message
> news: aa6f6d$590$1_at_fe1.cs.interbusiness.it...
> > the query with a SELECT statement use the rollback segment? I execute a
> > query on Oracle 7.3.4 and the programme gave me the error: "snapshoot
too
> > old: rollback segment NAME too small (ORA 01555)"
> >
> >
> >
>
>
Received on Wed Apr 24 2002 - 10:46:25 CDT
