Showing posts with label Toad for Oracle. Show all posts
Showing posts with label Toad for Oracle. Show all posts

Tuesday, April 17, 2012

Toad hangs when retrieving User Script 

When using the Schema Browser, user selects select a User and the User Script tab. Toad hangs (or taking a long time) on a 10g db. When user uses 9.2.0.5 database, User script works as it should.

Does not appear to matter which user is selected . Toad does not return script and it hangs. Changing the Optimize hint does not address issue.

Also, right-clicking a user then clicking Create Script does not work no matter to File, to Screen, or to Clipboard.