I run a select and data is in the data grid view ( bottom pane), I select "Save As",and regardless of the options ( save as inserts, to clipboad),
the app hangs for a good 4-5 minutes before completion. During that time, toad.exe is using ~75% CPU. This behavior is unrelated to the data set size, it could be 1 row.
Very large, possibly corrupt ToadActions.dat file
1) Close Toad for Oracle.
2) For Windows XP - Go to 'C:\Documents and Settings\<OS_USER>>\Application Data\Quest Software\Toad for Oracle\<Toad Version>\User Files' directory.
For Windows Vista and 7 - Go to 'C:\Users\<OS USER>\AppData\Roaming\Quest Software\Toad for Oracle\<Toad Version>\User Files' directory.
(a) Rename the ToadActions.dat file to ToadActions.dat.backup.
(b) Rename the ToadActions.log to ToadActions.log.backup
3) Launch Toad and test issue.
Please review additional information below before carrying out the above tasks.
The ToadActiions.dat file also stores the Apps from App Designer (Automation Designer). If you are able to access AppDesigner then, prior to renaming the ToadActions.dat, you should export any user defined Apps you have created first. Once the new ToadActions.dat is created, you can then import your user defined apps.