This happens when you have a long running query or update and the before
image has been overwritten in your rollbacks.
You can either
Extend your rollbacks
Or
re-write whatever is causing your issue.
Michael Peel
-----Original Message-----
From: K Sivakumar
[mailto:oracledba-ezmlmshield-x98700119.[Email address protected]
Sent: 31 March 2008 11:45
To: LazyDBA Discussion
Subject: 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
Join the Collaborative Business Experience at www.capgemini.com
<http://www.capgemini.com>
This message contains information that may be privileged or confidential and
is the property of the Capgemini Group. It is intended only for the person
to whom it is addressed. If you are not the intended recipient, you are not
authorized to read, print, retain, copy, disseminate, distribute, or use
this message or any part thereof. If you receive this message in error,
please notify the sender immediately and delete all copies of this message.
---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html
**********************************************************************
This e-mail is confidential and may be privileged.
It may only be read, copied and used by the intended recipient.
If you have received it in error please contact the sender immediately
by return e-mail. Please then delete the e-mail and any copies of it
and do not use or disclose its contents to any person.
**********************************************************************
Registered Office: Farncombe House, Broadway, Worcestershire, WR12 7LJ
AccuRead Limited Registered Number: 3076187 England
GSL UK Limited Registered Number: 3333860 England
Global Solutions Limited Registered Number: 3189802 England
**********************************************************************
Oracle LazyDBA home page