--创建dblink create public database link a --dblink连接名 connect to user identified by password--用户名和密码 using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 数据库IP地址)(PORT = 1521))) (CONNECT_DATA =(SERVICE_NAME = orcl)))'; --测试dblink select * from MPI_CONF_FIELD@a --删除dblink drop public database link a; -- 查询现有的dblink select * from dba_db_links;
转载请注明原文地址: https://www.6miu.com/read-600094.html
