Oracle 创建database link

用途：在当前数据库查询远程数据。

--创建database linkcreate database link dbcenter1connect to 用户名identified by 密码using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.0.1)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=dbcenter)))';-- 查询数据select * from table_name@dbcenter1;