Data reverts back on commit
799084Sep 20 2010 — edited Sep 22 2010I'm trying to update the data in one of my tables. I launch SQLPlus, do a SELECT to see the old data, run an UPDATE statement and then do a SELECT again to verify that the change is done. However, once I run COMMIT and then run my SELECT again, I don't see my change. It seems to be the case that there's some other connection that's holding a lock on that table or something which isn't allowing me to save on commit. There's nothing in the database logs specifically for this table.
I tried running some queries I found to identify which process may have a lock on this table or something, but couldn't find anything. The column that I'm updating in this table does not have any referential constraints whatsoever.
Any ideas how I can identify what the problem is and what might be the culprit here ?
This is a 11g database if that helps
Edited by: user11960166 on Sep 20, 2010 5:24 PM