创建dblink
create database link dbl_hc connect to dlky identified by dlky using ‘(DESCRIPTION=
(CONNECT_DATA=(SERVICE_NAME=orcl))
(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)));’
dlky就是目标数据库用户名和密码
HOST=localhost换成目标数据库IP地址
SERVICE_NAME=orcl将ORCL换成他们新建的数据库名
查看dblink
select * from dba_db_links
删除dblink
drop database link dbl_hc