oracle给用户赋dblink权限
create database link 别名(可任意起)
connect to 需要连接库的用户名identified by 需要连接库的用户名
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 10.50.182.11)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = testdb)))';
create database link 别名(可任意起)
connect to 需要连接库的用户名identified by 需要连接库的用户名
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 10.50.182.11)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = testdb)))';