Re: out of memory - executing a select statement

savindya wrote:
> 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

*Which* out of memory error?
Please do NOT assume we are looking over your shoulder and can guess what 'the out of memory error' and 'impossible to use stored procedures' means.
The options which are available are
- be more specific
- be more specific
and
- be more specific

-- 
Sybrand Bakker
Senior Oracle DBA