oracle中dblink查看、创建、使用以及删除实例代码

--查看全部用户

SELECT OWNER,OBJECT_NAME FROM DBA_OBJECTS WHERE OBJECT_TYPE= 'DATABASE LINK' ;

--查看全部用户

SELECT * FROM DBA_DB_LINKS;

--查看本用户

SELECT * FROM USER_DB_LINKS;

给scoot用户权限

GRANT CREATE PUBLIC DATABASE LINK,

CREATE DATABASE LINK TO scoot;

--  (connection为dblink名字,scott为数据库用户名,tiger为用户名密码,引号内容为远程数据库下tnsnames.ora文件内容)

create database link connection

     connect to scott identified by "tiger"

     using '(DESCRIPTION =

     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.100.52)(PORT = 1521))

     (CONNECT_DATA =

       (SERVER = DEDICATED)

       (SERVICE_NAME = orcl)

     )

   )

' ;

SELECT * FROM   DEPT@ connection ;

drop database link connection ;

select d.* from dba_dependencies d where d.referenced_link_name= 'XXX'