Re: Data Pump slower than equivalent Export ?!?

On Fri, 16 Sep 2005 20:18:05 +0200, Ronald Rood wrote:

> The ftp session alone of the conventional expdat.dmp (49GB) of
> the same database took 1 hour and 20 minutes...

You should have used scp with "-C" argument. It turns the compression on and copies much faster then ftp ever could. If you are enamored by the ftp's put/get/mput/mget/prompt command set, you can use sftp. In my opinion, ftp and kermit commands are from the same period and both suck. I use scp whenever I can.
As for "data pump" utilities, their main advantage comes from the fact that they're able to use parallelism. Expdp can, in contrast to exp, use parallel query, while impdp can do parallel DML. In order to see an improvement, one needs to use a database which can utilize parallelism.

-- 
http://www.mgogala.com