out of memory - executing a select statement

Hi all,

I m using oracle 9i as the db. And a certain table has 1330391 records in it.
I use PLSQL developer to query on the db.

When I execute a simple SELECT * FROM tablename , the system fetches about 208,595 records and halts with the out of memory error.It is impossible to use any stored procedures on this table also.Please advice on what options are available.

regards,
Savindya Received on Sun Jan 07 2007 - 23:59:10 CST