========================================================DB Link的创建及使用====== drop public database link dblink_csm; --如果已存在，先drop掉 create public database link DBLINK_CSM connect to CSM identified by qwer1234 --CSM为用户名，qwer1234 为密码 using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.51.125)(PORT = 1521)) --192.168.51.125为IP ，1521为端口号 (CONNECT_DATA = (SID = orcl) --orcl为数据库实例名 ) )'; --测试dblink是否连接成功 select * from dual@dblink_csm; ================================================================================= --删除dblink 在plsql中左侧 myobjects中找到Database links 刷新 然后选中想删除的某个dblink 右键 drop