A script of the following flow is getting an “out of memory” error in version 12.1. Don’t need data in a grid just in the file. Is there a way to perform script without putting data in the grid?
spool c:\temp\file.txt
select * from table;
spool off
I would execute that in SQLPlus. Right-click and chose the
Execute|Execute via SQLPlus item. That will free Toad up so you can do
other things as well.
On 03/06/2014 10:46 AM, stephen.huff wrote:
spool c:\temp\file.txt
select * from table;
spool off
=
There is also an option in Options -> Scripts -> Script output to turn off the grid. I would also make sure that Maintain Script History is unchecked.
Options -> Scripts ->Script output to turn off the grid.
This option exact name is: "Show Script Grids"