Archives of the TeradataForum

Message Posted: Fri, 06 Oct 2006 @ 14:12:24 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

We have heard of this error before - although usually after a much larger number of rows has been returned. (But maybe your rows are very large, or your available memory is small.)

When you return data to an Answerset window that data is held entirely in memory so it is certainly possible to run out of memory - especially if you have other apps running at the same time.

The only real solutions here are:

a) Use Export instead of returning the data to the Answer window. (During Export only a single row is stored in memory.)

b) Shut down some applications that are running. (Especially other memory intensive apps.)

c) Add memory to your system. (Either Real or Virtual)

Mike Dempsey
Teradata Client Tools

	<Prev	Next>		<<First	<Prev	Next>	Last>>