How to Export Data from a Huge non-clustered Oracle Table

Lefteris · Post by **Lefteris** » 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

Plash · Post by **Plash** » Wed 08 Oct 2008 07:30

You should use FetchAll = False and UniDirectional = True for a huge table.