不落地数据导入导出

zbdba= 
(DESCRIPTION = 
(ADDRESS_LIST = 
(ADDRESS = (PROTOCOL = TCP)(HOST = zbdba)(PORT = 1521)) 
) 
(CONNECT_DATA = 
(SID = zbdba) 
) 
) 

CREATE DATABASE LINK <database link name> CONNECT TO <remote database user name> IDENTIFIED BY <remote database password> USING &#39;<tnsname connect to remote>&#39; 

impdp zbdba/zbdba network_link=zbdba_link remp_schema=source_schema:target:shcema remap_tablespace=source_tablespace:target:tablespace

source：
mknod /tmp/exp_pipe p
target：
mknod /tmp/imp_pipe p
配置两个机器的互信

dd if=/tmp/exp_pipe | ssh 192.168.56.42 dd of=/tmp/imp_pipe

然后打开另外一个窗口进行导入：

exp zbdba/zbdba file=/tmp/exp_pipe log=zbdba.log tables=zbdba