TOAD 12.9.39 32bit on Windows 7
I have a large oracle schema (14500 objects) that I am trying to add to Team Coding and Subversion.
After creating the team project successfully, I started the process of creating initial revisions in SVN and let it run overnight.
When I arrived in the morning, the progress dialog indicated that the process had completed. However, there was an error dialog on the screen that indicated TOAD had encountered an oracle error:
ORA-01555 Snapshot Too Old
I think this simply means that I need a bigger rollback segment, if I’m going to run such long update statements. Still, I’m not sure if this represents an event that may have left the process incomplete. I saved the log file, and closed the dialog box, and I received the following error from TOAD:
Cannot create file “…\TOAD_EC9E\User Files\VCPDebug.log”. The process cannot access the file because it is being used by another process. (Note- I was running this instance of TOAD using the /virtual command line parameter.)
when I closed this dialog, TOAD appeared to restart.
However, TOAD now seems to go in a loop and fails to complete the process of connecting to my database. After selecting the loging profile from the Database Login dialog, I get the SVN login dialog. That one closes, but the Database Login dialog will not close, and it just flashes between showing the (not responding) tag in the title bar, and not showing it.
However the entire TOAD UI remains unresponsive.
I’ve killed TOAD at the task manager a couple of times, but the behavior is the same each time.
It’s possible that TOAD is just doing work to read all the team coding data at startup time, so I’m just going to leave it and see if it completes successfully.
But for now, I am unable to run TOAD.
Any suggestions are welcome.