删除dblink
drop database link linkname;--要删除的link名称
创建dblink
create database link name_link
connect to tname IDENTIFIED BY pwd
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = 192.168.0.203)
(PORT = 1521)) )
(CONNECT_DATA =
(SERVICE_NAME = orcl)
) )';