Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Row Locks?
Hi
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 - 09:32:44 CDT