How to Export Data from a Huge non-clustered Oracle Table
Posted: Tue 07 Oct 2008 08:59
Using:
ODAC Net 5.55.1.24
Oracle 10.2.0.1.0
OraTools add-in 2.60.2.17
Trying to export to .csv large number of records, (150000+) from a table using TOraQuery.
Using FetchAll := True and a straight "Select * from ..."; the "Out of Memory" error is received. When using OraDesigner with the same SQL statement all works fine.
Can you please suggest ways to alleviate the problem and perhaps the code segment in OraDesigner ?
Thank you in advance
ODAC Net 5.55.1.24
Oracle 10.2.0.1.0
OraTools add-in 2.60.2.17
Trying to export to .csv large number of records, (150000+) from a table using TOraQuery.
Using FetchAll := True and a straight "Select * from ..."; the "Out of Memory" error is received. When using OraDesigner with the same SQL statement all works fine.
Can you please suggest ways to alleviate the problem and perhaps the code segment in OraDesigner ?
Thank you in advance