Toad hangs during export of blobs using the Export Blobs option (data grid | right click | export blob).
I choose to export xml data (datatype blob) into a local directory, and choose to "Export to files named for the value in this column", specifying a column of datatype varchar2(200). The actual strings are about 13 characters long. If I choose to export with sequential numbered file names instead, it exports all rows without problem.
Toad export a few hundred rows then hangs, no errors are given, and I have to use task manager to kill Toad. In some cases it exports about 111 rows, others 791 rows, sometimes 706 rows... it can vary, and it does not seem to stop at any specific row/data. The only thing so far that is consistent is that it will hang and only when using Export Blob with the option "Export to files named for the value in this column".
WORKAROUND:
Make sure Options | Data Grid | Data | "Preview CLOB and LONG data" unchecked. With this option checked, Toad is reading all those lobs into the grid. This can cause problems with a lot of rows or big clob data.
STATUS:
Waiting for fix in a future version of Toad for Oracle.
Tested in versions 9.6.1 and 9.7.
© ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center