It seem to be a problem with rollback segment... you should increase or
commit in several steps
Ciao


-----Mensaje original-----
De: K Sivakumar
[mailto:oracledba-ezmlmshield-x98700119.[Email address protected]
Enviado el: lunes, 31 de marzo de 2008 12:45
Para: LazyDBA Discussion
Asunto: snapshot too old


Dear DBA,

Would you tell me what snapshot too old error. When does it
happen? What are the possible causes? How to fix it?

ORA-01555: snapshot too old: rollback segment number 11 with
name _SYSSMU11$ too small

Thank you very much.



Regards,

Sivakumar.K

IT | Capgemini | Chennai

Ph : 044 39839366 | Extn : 39366



No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.1/1350 - Release Date: 30/03/2008
12:32



Oracle LazyDBA home page