I’m a heavy user of the workspace feature of toad. Now our DBAs are planing to replace the connection strings in the tnsnames.ora (because the host name will change due to a hardware upgrade). Unfortunately My saved editor tabs do not load as long as the connection for them is not established. Therefore I will not be able to open my saved editor tabs.
I’ve tried to search & replace the connection strings in the file “Workspaces.dat” which rendered it unreadable for Toad.
Is there any way to replace the connections for the saved workspaces?
Wonder if you got any traction on this issue, no one has replied but have you been able to find a workaround?
I use workspaces a fair bit. I have one workspace that is only half loading and then it hits a database that is not available and it stops completely, it does not load up the rest of the workspace. I have allot of critical details about a current project I am working on in tabs that are not loading because of the connection error, and I do not know what database it is failing on. I have about 30+ databases to choose from so just not practical to try and figure which one it is.
Worked like a charm and was able to identify the database not connecting.
For the other novices, like myself, I did have to copy out the text and search for "ORA-" to find as the the error was not he last in the Spool SQL log.