Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Ultra Rapid data extraction/migration

Ultra Rapid data extraction/migration

From: Peter Lomax <plomax_at_bouyguestelecom.fr>
Date: 1998/08/28
Message-ID: <35E71B8D.64FD7EAE@bouyguestelecom.fr>#1/1

Found a cool tool.
Dynamic parallel processing
Extract through views historic or range data Works with views on old Version 7 tables so you can split them by your key(e.g. by month) for version 8 partitions It does multiple // downloads of data, based on number of CPU's, this can be piped directly with sqlloader direct path, unrecoverable into the partitions.
I have done by 12Go tables in 8 partitions really fast. - 25 minutes The idea of views is great I use it for pulling off todays modified data

as well.
I found it on www.oriolecorp.com - PDQOUT Cheers
Peter Received on Fri Aug 28 1998 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US