Re: Fast extracting of large Oracle tables into flat text file

[Ales Kavsek]

You should try free SQLExp utility (www.sqltools.net). It dumps sql query in csv file and it's very fast (written in pure C with OCI)! First you specify some parameters in control file like this one (it will dump table1 and table2 to cvs):

delimiter=,
quote="
quoteEscape="
output=table1.csv
statement=select * from table1
/

delimiter=,
quote="
quoteEscape="
output=table2.csv
statement=select * from table2
/

If you're looking for some "magic" tool that won't hurt database performance while dumping huge table let me know when you find it! (And good luck, because it won't be easy to find one ;-)

regards,
Ales