CREATE DATABASE LINK TEST2 CONNECT TO TEST IDENTIFIED BY TEST USING 'TEST2';
创建DBlink, CREATE DATABASE LINK LINK_NAME CONNECT TO USER_NAME IDENTIFIED BY PASSWORD USING 'DATABASE'; LINK_NAME为建立的DBLINK名称,USER_NAME 为要连接的用户名,PASSWORD 为密码,'DATABASE'为数据库连接串, 访问表时需要加@,例如用户USER1通过DBLINK访问用户USER2的表t,则这样写: SELECT * FROM USER2.T@LINK_NAME
dblink 确实可以,就是慢....
创建DBlink, CREATE DATABASE LINK LINK_NAME CONNECT TO USER_NAME IDENTIFIED BY PASSWORD USING 'DATABASE'; 在orcl1的users1下面创建: create database link orcl1_orcl2 connect to user2 identified by password using 'orcl2';insert into tables.* values(select * from table2@orcl1_orcl2)
CREATE DATABASE LINK LINK_NAME CONNECT TO USER_NAME IDENTIFIED BY PASSWORD USING 'DATABASE';
LINK_NAME为建立的DBLINK名称,USER_NAME 为要连接的用户名,PASSWORD 为密码,'DATABASE'为数据库连接串,
访问表时需要加@,例如用户USER1通过DBLINK访问用户USER2的表t,则这样写:
SELECT * FROM USER2.T@LINK_NAME
CREATE DATABASE LINK LINK_NAME CONNECT TO USER_NAME IDENTIFIED BY PASSWORD USING 'DATABASE';
在orcl1的users1下面创建:
create database link orcl1_orcl2 connect to user2 identified by password using 'orcl2';insert into tables.* values(select * from table2@orcl1_orcl2)