在db1中创建db2的同义词(在db1中也能查询db2的数据表)
同一个Oracle实例:
create or replace synonym db1.customer for db2.settratingcdren;
不用Oracle实例:
先创建database link
Create database link db2_link connect to db2 identified by password using '192.168.xx.xx:1521/xx';
create or replace synonym db1.settratingcdren for db2.customer@db2_link ;