Exporting Table Data as CSV
415477Feb 23 2004 — edited Feb 23 2004I am having to export a schema's tables in CSV format. The largest has 10,000,000 rows.
I've written an SQL*Plus script that automatically creates a SQL script for each table using the USER_TABLES view. So far, so good...
Unfortunately, running the 10,000,000 row export script, for example, takes 20 hours (down from 40 hours thanks to several SET commands to aid efficiency). The output file is 900Mb.
Is there a better (as in quicker) way? I threw it at TOAD which, er, croaked!