用expdp远程导出dmp文件并impbp导入数据库

1．需求
远程导出数据库dmp文件，然后用impbp将dmp文件导入数据库

2．步骤
1、本地数据库用户（sys）创建network_link:
2、本地数据库用户（sys）创建目录并针对导出用户（system）对该目录授予读写权利
3、用expdp语句远程导出数据库dmp文件到本地

3．实例
（1）基本信息
本地数据库信息
用户： localDBuername/localDBpasswd
表空间名：localDBspacename
远程数据库信息
TNS：
TNSORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 远程数据库服务器IP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
)
)
用户：remoteDBUername/remoteDBpasswd
表空间名：remoteDBspacename
（2）导出dmp文件
create public database link netlinkname connect to remoteDBUername identified by remoteDBpasswd using ‘TNSORCL’
create or replace directory dumpdir as ‘D:\localFilename\’
grant read,write on directory dumpdir to localDBuername
expdp localDBuername/localDBpasswd network_link = netlinkname directory = dumpdir dumpfile = remoteDB.dmp logfile = expdp.log schemas = remoteDBUername
（3）将dmp文件导入到数据库
impdp localDBuername/localDBpasswd directory = dumpdir dumpfile = remoteDB.dmp logfile = impremoteDB.log version = 11.2.0.1.0 remap_tablespace=localDBspacename:remoteDBspacename remap_schema=localDBuername:remoteDBUername