Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Ultra Rapid data extraction/migration
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
![]() |
![]() |