create public database link ycydatabase connect to mw_sys identified by sys using 'aoonging';--查询链接数据库中的数据 select * from mw_app.mwt_userinfo@ycydatabase;
PL/SQL DEV工具里面有创建DBLINK的工具呢,在左下的目录里你也可以SQL创建 -- Create database link create public database link LZCCB connect to LZSIT using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.156.66)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = lzccb) ) )';之后使用的时候,直接使用那个数据库的表名,之后加上@+dblinkname,如: select count(*) from ln_reg@lzccb;
建议用下面方式建立,应该是最简洁的. CREATE PUBLIC DATABASE LINK dblinkname CONNECT TO user IDENTIFIED BY pwd USING 'IP:1521/实例名'例: CREATE PUBLIC DATABASE LINK nsj820 CONNECT TO system IDENTIFIED BY oracle USING '128.1.2.112:1521/orcl'
关于dblink
select * from mw_app.mwt_userinfo@ycydatabase;
-- Create database link
create public database link LZCCB
connect to LZSIT
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.156.66)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = lzccb)
)
)';之后使用的时候,直接使用那个数据库的表名,之后加上@+dblinkname,如:
select count(*) from ln_reg@lzccb;
CREATE PUBLIC DATABASE LINK dblinkname CONNECT TO user IDENTIFIED BY pwd USING 'IP:1521/实例名'例:
CREATE PUBLIC DATABASE LINK nsj820 CONNECT TO system IDENTIFIED BY oracle USING '128.1.2.112:1521/orcl'