thread error

[chuck]

I was trying to look at a large view (130,000 rows no blobs).

I get Thread creation error: Not enough storage is available to process the command.

I have 10s of gigs available.

PL/SQL Developer
Version 6.0.2.880 (MBCS)
43.21281 - 1 user license
Windows XP version 6.0 (build 2600) Service Pack 2

Physical memory : 1,571,828 kB (469,820 available)
Paging file : 3,516,728 kB (2,416,156 available)
Virtual memory : 2,097,024 kB (31,264 available)

Parameters
C:\Program Files\PLSQL Developer\PLSQLDev.exe

Preferences
Session mode: Multi
OCI Library:
Use OCI7: False

Plug-Ins

Aliases
BEQ-LOCAL.WORLD
CMEXAMPLE.WORLD
EI_Prod
EI_Test
EXTPROC_CONNECTION_DATA.WORLD
...

Homes
OraHome92 (C:\oracle\ora92)

DLLs
C:\oracle\ora92\bin\oci.dll

TNS File
C:\oracle\ora92\Network\Admin\tnsnames.ora

Using
Home: OraHome92
DLL: C:\oracle\ora92\bin\oci.dll
OCI: version 9.2
Oracle8i Enterprise Edition Release 8.1.7.4.0
Character size: 1 byte(s)

 

[Marco Kalter]

Did you query this view? If so, did you query all records?

 

[chuck]

Right click on the view pick, Query Data

The view begins to execute and the number of rows returned so far are shown in the status bar.

After upgrading to 6.0.5, I now get a message in the status bar "Out of memory"

If I click the little wheel on the open window with the select statement. I get the message:
"List index out of bounds (104130)"

or

Access violation at address 005ba1ec in module 'plsqldev.exe'. Write of address 00003326

 

[Marco Kalter]

You should preferably use the "Export Query Results" button to the right of the SQL Window. This way the query results will directly be written to a file, without any memory overhead.

I assume you want to export the data, and do not actually wish to view 130,000 records?

 

[chuck]

I wanted to view it