MySQL Forums
Forum List  »  Oracle

Re: Fast extracting of large Oracle tables into flat text file
Posted by: Ales Kavsek
Date: August 06, 2004 03:39AM

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



Options: ReplyQuote


Subject
Views
Written By
Posted
Re: Fast extracting of large Oracle tables into flat text file
3352
August 06, 2004 03:39AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.