create database link linka
connect to demo
identified by demo
using 'demona';//demona为用net8 easy config创建的连接字符串
目的方数据库的init.ora文件中的global_names设为falseSQL> set serveroutput on;
SQL> declare
2 trol job@linka%rowtype;
3 begin
4 select * into trol from job@linka where job.job_id=667;
5 dbms_output.put_line(trol.job_id);
6 end;
7 /
667PL/SQL 过程已成功完成。
login db1,
create database link db1_to_db2 connect to scott identity by tiger
using dbscv2;
再db1下可以用db1_to_db2 访问db2