|
|
| Re: snap shoot too old ora 01555 [message #52489 is a reply to message #52484] |
Thu, 25 July 2002 07:45   |
Radek
Messages: 33
Registered: April 2002
|
Member |
|
|
check out your rollback segments. Generally there should one rollback segment per 15 sessions. You are getting this error bevause your rollback are too small or you have unsufficient number of segments.
Radek
|
|
|
|
| Re: snap shoot too old ora 01555 [message #52492 is a reply to message #52484] |
Thu, 25 July 2002 08:07 |
Sanjay Bajracharya
Messages: 279
Registered: October 2001
Location: Florida
|
Senior Member |
|
|
Snapshot too old is the most annoying error you can ever get in Oracle.
1. as Radek said, check your rollback segments
2. If you are doing a HUGE job, see to it that no one else is trying to do anything else in the table you are working on.
3. Increase the commit level. (Yes I said INCREASE, sounds funny but is true).
Good luck.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
