Re: Running import datapump over a database link.

> if I remember correctly, nothing is compressed when you data pump over a dblink.

Maybe you're referring to this?

IMPDP using network_link ignores table compression in 10gR2 (Doc ID 975822.1)

The problem does not exist in 11g.

Speaking of tranferring a dump file over, I have some success with using NFS to avoid scp'ing the file across nodes. Just make sure the NFS read and write buffer is set larger, e.g.

mount -t nfs -o hard,intr,rsize=32768,wsize=32768 nfssvr:/path /path

You can use another box as the NFS server, or use one of the two nodes involved in data pump as the server. If the source and target data pump nodes are about equal in performance, it's probably better to choose the source as the NFS server, because during impdp, the bottleneck may be on the target side instead of the network. But test both to find out. If you can't write logfile to the NFS mount point, just write it somewhere else, e.g. logfile=somelocaldir:impdp_from_nfs.log or don't log (nologfile=yes).

Yong Huang

--
http://www.freelists.org/webpage/oracle-l