1.在当前数据库下查看所有的DBLINK的方法
select * from dba_db_links;
2.创建
create public database link dbLinkName --(dbLink的名字,任意指定)
connect to username identified by password
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP )(PORT = 1521))--(IP:ORACLE服务器的IP地址)
)
(CONNECT_DATA =
(SERVICE_NAME = SID) --(ORACLE服务器的服务标识)
)
)';
3.使用
select count(*) from tableName@dbLinkName ;
4、删除
--删除DBLINK
DROP DATABASE LINK [name];
--或
DROP PUBLIC DATABASE LINK [name];