Toad World® Forums

How to run script without filling grid, due to grid out of memory error?


#1

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


#2

I would execute that in SQLPlus. Right-click and chose the
Execute|Execute via SQL
Plus 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
=


#3

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.


#4

Options -> Scripts ->Script output to turn off the grid.

This option exact name is: “Show Script Grids”