Re: Migrate 200 Million of rows

> Don't use a database link! This is intended for "small" quantities of
> data! If I were you, I'd spool everything in a flat file, transfer the
> file to the other database server, and do a "direct-load" SQL*Loader
> import. My guess is that that would be the fastest way.

For common, every day queries, I'd say to keep the amount of data transferred across a database link to a minimum. But why not use a db link for a one time data load?

Cheers,
Brian

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"