Re: select e rollback segment

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)"

>

>

>