Wednesday, June 26, 2013

Best Way to Export billions of rows from Oracle, DB2, MSSQL, MySQL, Teradata, Netezza, Sybase, PostgreSQL

Hi All.

The best way to export large volume of data from Oracle (or any other databases) to CSV is by DBCrane ( Toad is not designed for large data volume. DBCrane is also many times faster than sqlplus/spool or utl_file and it doesn't require any coding. We use DBCrane to export billions of rows from Oracle, SQL server and Netezza into delimited files and the process is done in less than one hour.

I tried Util_File package but it failed, then i tried CSV Exporter library for Java, but it failed as well. But DBCrane did this job well.


Ujjwal Soni

No comments: