SEE ATTACHMENT
Hi Wendy,
Toad still doesn’t do well when Oracle is pulled away from it in the middle of
the night. This is a systemic problem I think.
Regarding document recovery, there was an enhancement a couple of releases back
which came from user requests to have the database connection which was tied to
a file automatically occur when the file is recovered. Your long 25 second pause
is happening because it’s trying to re-establish the connection to ITHACA@SISQA
and is failing. The information about which document is tied to which connection
is kept in the temporary file ~EditorBackups.txt, which is in the User Files
folder, as you probably know.
All files in all tabs of all open Editor windows are backed up, regardless of
whether any change was made to them. You can view all of the temporary files in
your User Files folder while Toad is running. They are the ones prefixed with
“~eb” with a .tmp extension.
I was trying to figure out your workflow. By ‘second instance of Toad’ do you
mean the same version? If so, it doesn’t follow that the ‘cut & paste’ works
since the destination is the same as the source (same User Files folder).
anyway, maybe some of what I said helps.
Maybe a useful enhancement request would be to have a check box on the document
recovery window to not automatically reconnect to the database - just recover
the file.
Mark
Hi Wendy,
Toad still doesn’t do well when Oracle is pulled away from it in the middle of
the night. This is a systemic problem I think.
Regarding document recovery, there was an enhancement a couple of releases back
which came from user requests to have the database connection which was tied to
a file automatically occur when the file is recovered. Your long 25 second pause
is happening because it’s trying to re-establish the connection to ITHACA@SISQA
and is failing. The information about which document is tied to which connection
is kept in the temporary file ~EditorBackups.txt, which is in the User Files
folder, as you probably know.
All files in all tabs of all open Editor windows are backed up, regardless of
whether any change was made to them. You can view all of the temporary files in
your User Files folder while Toad is running. They are the ones prefixed with
“~eb” with a .tmp extension.
I was trying to figure out your workflow. By ‘second instance of Toad’ do you
mean the same version? If so, it doesn’t follow that the ‘cut & paste’ works
since the destination is the same as the source (same User Files folder).
anyway, maybe some of what I said helps.
Maybe a useful enhancement request would be to have a check box on the document
recovery window to not automatically reconnect to the database - just recover
the file.
Mark
Just for my own documentation purposes - this was resolved off line.
The issue was with the Toad Home. Support to the rescue again, they figured it
out. They’re good.
So this is an easy fix, I just need to store the Home along with the other data,
to ensure it matches the active Toad Home before attempting the connection. But
the ‘re-connect’ checkbox in the recovery grid is still probably worth doing
too.
Just for my own documentation purposes - this was resolved off line.
The issue was with the Toad Home. Support to the rescue again, they figured it
out. They’re good.
So this is an easy fix, I just need to store the Home along with the other data,
to ensure it matches the active Toad Home before attempting the connection. But
the ‘re-connect’ checkbox in the recovery grid is still probably worth doing
too.