创建dblink

-------创建dblink
--create public database link test  --dblink 名称
create  database link test  --没有public 就是当前创建用户可用
connect to test--数据库用户名称
identified by test--用户密码
using   
'   (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = test )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = test)
    )
)'


---查看dblink
select owner,object_name from dba_objects where object_type='DATABASE LINK';
select * from dba_db_links;
--删除dblink
drop public database link WD; --dblink 名称
--通过dblink 查看目标表
select * from table@dblink;