DB Link的创建与使用(Oracle)
========================================================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 (编辑:李大同) 【声明】本站内容均来自网络,其相关言论仅代表作者个人观点,不代表本站立场。若无意侵犯到您的权利,请及时与联系站长删除相关内容! |