去掉oracle dblink长长的domain 后缀

 

select * from global_name;

 

update global_name a
set a.global_name='&SidName';

 

SHUTDOWN IMMEDIATE

STARTUP

select * from global_name;

 

重建dblink

select * from user_db_links;