How can I "batch download" data from Oracle?

Question

I'm looking for a tool/technique which is the exact oposite to Oracle Loader. I need to read the whole table with geometries as fast as possible. The application is running on the same machine where Oracle is installed so some kind of "direct" access is possible. The table has around 3 millions records and fetching this amount of data through ordinary client (11 beta -> .Net DevArt Oracle dotConnect driver in OCI mode) takes roughly 6 hours(!). I don't need to execute any queries and the table does not contain any calculated fields or references.

Is it possible?

Answer 1

Hi,

Just to clarify, do you need to get the data from the oracle table into a flat file? If so Tom Kyte has several examples http://asktom.oracle.com/tkyte/flat/index.html

Regards

Answer 2

Where is the data going ? If you want an Oracle compatible 'backup' to load into another database, then look at exp or expdp.