oracle 跨库访问(oracle to oracle)

1.如果用户具有跨库访问的权限。
/*建立跨库连接*/
create public database link dblink
connect to ERPDB /*用户名*/identified by web3nod /*密码*//*数据库地址*//*实例名*/
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.62 )(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = topprd )
)
)';


select * from T_SD_MODEL@dblink; /*查询远程数据要加上@加链接名称*/
/*删除跨库连接*/

drop public database link dblink;