telecomHall.com | Hunter Blog | Tips Blog | Course Blog | Groups

TOAD Export Out of Memory problem


#1

Hello Experts.

I am using Toad for Oracle.

I am trying to export 490k records.

Seems it has a problem - Out of Memory.

Anyone using Toad, and can help?

Note: i have followed the telecomHall tutorial (http://www.telecomhall.com/using-toad-as-best-free-database-management-tool.aspx), and it was working perfectly the latest 5 years.

Just now this error appear.

Help please.


#2

It’s easy to solve, as it is a “known” problem.

When exporting, UNCHECK the option “Display all results in grid”

It is the option to have the grid mirror what you write to the file. It was common in older versions of TOAD: “clone cursor”.


#3

Thank You very much.

It worked! :slight_smile: