create database link dblinkname connect to user identified by pwd using '服务名'
远程数据连接DBLink: create database link SIDBJ.US.ORACLE.COM connect to userbj identified by bj123 using 'tns_xj_to_bj'; 其中:SIDBJ.US.ORACLE.COM是远程的数据库的global_name,userbj是连接SIDBJ的用户名,bj123是userbj的密码, tns_xj_to_bj是本地建立的连接到远程数据库的服务名。
建个DBLINK吧!CREATE [PUBLIC] database link dblink_name connect to dbuser_name identified by dbuser_password using '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521)) (CONNECT_DATA = (sid = sid_name) ) )';
connect to user identified by pwd
using '服务名'
create database link SIDBJ.US.ORACLE.COM connect to userbj identified by bj123 using 'tns_xj_to_bj';
其中:SIDBJ.US.ORACLE.COM是远程的数据库的global_name,userbj是连接SIDBJ的用户名,bj123是userbj的密码,
tns_xj_to_bj是本地建立的连接到远程数据库的服务名。
connect to dbuser_name identified by dbuser_password
using '(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
(CONNECT_DATA =
(sid = sid_name)
)
)';