Row Locks?
From: Sunday Driver <jane_austen_at_geocities.com>
Date: Tue, 05 Jun 2001 14:21:27 GMT
Message-ID: <3b1cea0d.62185107_at_client.ne.news.psi.net>
Date: Tue, 05 Jun 2001 14:21:27 GMT
Message-ID: <3b1cea0d.62185107_at_client.ne.news.psi.net>
Hi
[Quoted] If 2 users try to update the same row at the same time, the one that gets there first gets to save and the other gets an error about the row having been modified by another user, right?
My (other) question is:
Has anyone ever heard of Oracle leaving some kind of permanent lock on
the row so that all users after that get the error msg about the row
having been modified by another user?
If not, why would all future users get the error when they try to
modify these rows?
TIA
Bryn
"In such cases as these,
a good memory is unpardonable." Received on Tue Jun 05 2001 - 16:21:27 CEST