I think TOAD resumes the session because, if you have a global temp table, and you store something to the table, it should only be available for the session. After your connection lost and you resume, the contents in the temp table is still there.
And I need to commit because, when I say "update ..." without a commit, the table is locked. I know the changes are not made, but you need to commit before another session can do delete all. For e.g., see http://asktom.oracle.com/p
"The delete from X will cause a FULL TABLE lock on both A and B before it starts
processing.
If another session has a lock on a row in X that your delete will ultimately hit
-- that will block your delete."
Main Topics
Browse All Topics





by: ploubierPosted on 2006-02-28 at 05:43:33ID: 16065017
You can't reconnect to a lost session : TOAD opens a new session with the cached credentials when you choose Test connections.
And if you were disconnected before committing your update, you don't have to delete anything.