I know this is a bit of long shot, but I’m really running out of ideas. I have used TOAD for Oracle to export a number of schemas DDL to local folders on a windows machine periodically. Recently one of the schemas on one of the instances I run it against causes TOAD to hang and never finish the export. No files are written, and I end up having to kill it. To be fair, TOAD is working great on a number of other schemas, so it’s not really a bug in TOAD I don’t think. But I’m unsure how to track down the true source of the problem and resolve it. I don’t think it’s a locking or blocking issue, the instance has been bounced and the problem persists, and the DBAs haven’t seen any visible problems when the job is running, although CPU usage is noticeably increased on the Oracle database server when it’s hung.
Below is the command line that launches the automation, and the control file that is fed into it specifying the schema to dump, and the options. I’m hoping someone might have some thoughts on how to troubleshoot further.
start “Running TOAD…” /WAIT “c:\program files\quest\toad for oracle 12\toad.exe” -a “Sync->One | c:\sync\source\schema.ctl”
Type=Generate Schema Script