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 link

create database link database_link_name
connect to username identified by "password"
using '(DESCRIPTION =
	(ADDRESS_LIST =
	(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
	)
	(CONNECT_DATA =
			(SERVICE_NAME = orcl)
	)
	)';