比如要将ybht_hs用户下的对象复制到另一个用户ybht_ty下
那么在ybht_hs用户下创建一个public database link
create public database link tolink connect to ybht_hs identified by "hs" using
'(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =10.138.129.4)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME =RLZY)
)
)';
impdp ybht_hs/hs@changde network_link=t
olink schemas=ybht_hs remap_schema=ybht_hs:ybht_ty
[remap_tablespace= HYGEIA:HYGEIA ]
其中@changde是tns中的服务名,这个一定要加上，网上有好多没有写上
该方法也只能在10.1及以上的版本使用
I’m impressed, I should say. Honestly rarely do I encounter a weblog that is both educative and entertaining, and let me tell you, you’ve hit the nail on the head. Your notion is outstanding; the concern is something that not enough people are speaking intelligently about. I am really pleased that I stumbled across this in my search for some thing relating to this. cheap jordans