grant create public database link to zhutianpeng; 用户
create public database link
dblink connect to 用户名 identified by "密码" using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =实例名)
)
)';
create public database link
dblink connect to 用户名 identified by "密码" using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME =实例名)
)
)';