Might someone can be interested in info how unload (export) large
Oracle table into text flat file in most efficient way. I came across
to FastReader from WisdomForce (www.wisdomforce.com). FastReader
bypasses Oracle engine by reading directly from data files. It uses
paralelism and unloading Oracle tables into flat text file with
separator that can be easy selected (like coma, etc..). At same time
FastReader generates control files for high speed loaders for various
databases like Oracle, MySQL, MSSQL, DB@, etc. (for instance sqlldr).
And most important that FastReader has high performance and low CPU
usage, that makes it ideal for using in large data centers for back up,
migration, etc.
Just FYI
Received on Sat Aug 28 2004 - 17:53:21 CDT
