(1)在sys用户下,把CREATE PUBLIC DATABASE LINK,DROP PUBLIC DATABASE LINK权限授予给你的用户
grant CREATE PUBLIC DATABASE LINK,DROP PUBLIC DATABASE LINK to yhjypt;
(2)
create database link kmsicp3_link
connect to kmsicp3 identified by kmsicp3 using '
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 192.168.5.5)
(PORT = 1521)) )
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
) )';
grant CREATE PUBLIC DATABASE LINK,DROP PUBLIC DATABASE LINK to yhjypt;
create database LINK yb_link
connect to kmsicp3 identified by kmsicp3 using '
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 192.168.5.5)
(PORT = 1521)) )
(CONNECT_DATA =
(SERVICE_NAME = ORCL)
) )';
create database LINK yb_link
本内容试读结束,登录后可阅读更多
下载后可阅读完整内容,剩余1页未读,立即下载