Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> newbee ROLLBACK/ COMMIT
Hi,
I'm a bit confused by the rollback command, I understand the function of
commit ,rollback & savepoint
But have the following questions.
1. do I have to use the savepoint command?
2. if my client crashes during the transaction , how long does the "temp
changes" sit around or is it dropped when I crash
3. if my client crashes, then re-logs in & then re-does the work and commits , will the server throw away the old crashed session or try to commit it when I issue a commit in a new session.
4. can anybody see any "temp" changes made to the database (including my client) before the commit has been issued.
5. how long between the commit & the changes becomming visible in the database
steve Received on Wed Aug 11 1999 - 05:25:31 CDT