Quickly unload (export) large Oracle table into text flat file
From: John Miller <john_miller_portland_at_hotmail.com>
Date: 28 Aug 2004 15:24:47 -0700
Message-ID: <7cca1f45.0408281424.3b25079a_at_posting.google.com>
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 [Quoted] 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_at_, etc. (for instance sqlldr). And most important that FastReader has high performance and low CPU usage, that makes it ideal for using in large datacenters for back up, migration, etc.
Just FYI Received on Sun Aug 29 2004 - 00:24:47 CEST
Date: 28 Aug 2004 15:24:47 -0700
Message-ID: <7cca1f45.0408281424.3b25079a_at_posting.google.com>
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 [Quoted] 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_at_, etc. (for instance sqlldr). And most important that FastReader has high performance and low CPU usage, that makes it ideal for using in large datacenters for back up, migration, etc.
Just FYI Received on Sun Aug 29 2004 - 00:24:47 CEST