Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> snapshot too old question
Hi,
I'm running 8.1.6 on solaris 7 and I'm getting a "snapshot too old" on a table that is not being updated. I thought I could only get this error if the table was being updated and the rollback came around on the rollback segment and over wrote my files I needed for read consistency. Why would I get this error on a table that is just being "select"ed not being update? Thanks in advance...
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Fri Nov 03 2000 - 00:08:46 CST