Oracle v7 snapshot too old
From: Michael Villanueva <micvil_at_lsupoz.apana.org.au>
Date: 25 May 1994 21:35:20 +1000
Message-ID: <2rvd5o$hhh_at_lsupoz.apana.org.au>
Date: 25 May 1994 21:35:20 +1000
Message-ID: <2rvd5o$hhh_at_lsupoz.apana.org.au>
We're currently using Oraclr V7 on a Pyramid Nile Machine. My problem is whenever I'm doing an update on a large table and one of my peers is doing a long query on another table, he's query crashes with the message 'snapshot too old'. I'm aware of the data consistency Oracle is trying to provide but this query is on another table. Is this an Oracle bug.? Received on Wed May 25 1994 - 13:35:20 CEST