oracle信息归藏

oracle信息收藏

1、创建数据库连接：

--授权grant create public database link to XXX;grant create database link to XXX;--删除权限（更改的时候需要用到）grant drop public database link to XXX;grant drop database link to XXX;--创建database linkcreate database link database_link_nameconnect to username identified by "password"using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME = orcl)))';