-- 如果创建全局 dblink,必须使用 systm 或 sys 用户,在 database 前加 public。 create /* public */ database link linkName connect to dbLoginId identified by dbLoginPassword using ‘(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.18.0.150)(PORT = 1523)) ) (CONNECT_DATA = (SID = gg150)(SERVER = DEDICATED)) )‘;
原文:http://www.cnblogs.com/fastsnail/p/6839768.html