没有问题!例: database link的名字叫link_nameSQL> select * from dept@link_name; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON已用时间: 00: 00: 00.02 SQL> create view v_dept as select * from dept@link_name;视图已建立。已用时间: 00: 00: 00.60 SQL> select * from v_dept; DEPTNO DNAME LOC ---------- -------------- ------------- 10 ACCOUNTING NEW YORK 20 RESEARCH DALLAS 30 SALES CHICAGO 40 OPERATIONS BOSTON已用时间: 00: 00: 00.40 SQL>
是的,需要把利用dblink用到的表先创建各同义词。 create synonym aaa for tab@dblink_aaa; create view as select * from aaa;
database link的名字叫link_nameSQL> select * from dept@link_name; DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON已用时间: 00: 00: 00.02
SQL> create view v_dept as select * from dept@link_name;视图已建立。已用时间: 00: 00: 00.60
SQL> select * from v_dept; DEPTNO DNAME LOC
---------- -------------- -------------
10 ACCOUNTING NEW YORK
20 RESEARCH DALLAS
30 SALES CHICAGO
40 OPERATIONS BOSTON已用时间: 00: 00: 00.40
SQL>
create synonym aaa for tab@dblink_aaa;
create view as select * from aaa;
是不是需要设置什么初始化参数?我把初始化参数里的 global_names 设为了 false,其他都是默认的值。