--授权
GRANT CREATE PUBLIC DATABASE LINK , DROP PUBLIC DATABASE LINK TO user_name;
GRANT CREATE SYNONYM TO user_name;
--查询DBLINK,DBA查询权限
select * from dba_db_links;
--创建DBLINK
CREATE PUBLIC DATABASE LINK to_dev CONNECT TO ctdev IDENTIFIED BY ctdev2017 USING '
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.16.64.66)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ctcore)
)
)';
--查询远程数据库的表
SELECT * FROM ctdev.grcode@to_dev;
--创建同义词，简化查询
CREATE SYNONYM grcode FOR ctdev.grcode@to_dev;
SELECT t.* FROM grcode t;
--删除DBLINK
DROP PUBLIC DATABASE LINK to_dev;
--删除同义词
DROP SYNONYM grcode;
--查看对象类型与归属
SELECT t.owner, t.OBJECT_TYPE FROM all_objects t WHERE t.OBJECT_NAME = 'USER_TABLES';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/30488948/viewspace-2137575/ ，如需转载，请注明出处，否则将追究法律责任。
