dblink

create database link link名称  connect to 对方数据库用户名 identified by 对方数据库用户密码  using '对方数据库ip:端口/实例名';

create database link auth  connect to zwww_auth identified by zwww_auth  using '//10.10.44.2:1521/orcl';




SELECT *
  from zwww_auth（数据库名）.t_role_user t
或者
SELECT *
  from zwww_auth（数据库名）.t_role_user@auth t

/*select *
  from ZHOUSHAN_20130620.bjxlb(用户名)@slt（dblink名） b
where b.bjlbbh = 60 and b.bjxlbh not in (select lxbm from t_soc_rcsjlx)*/

对于在代码上操纵垮库的，是可以的，但是封装太死不行的话可以用视图，这时只有用视图，在数据库上可以用普通方式

create or replace view v_syslog as
select "ID","TYPE","USER_ID","USER_NAME" as USERNAME,"LOG_DATE" as LOGDATE,"OPERATE","MESSAGE","IP","MAC","STATUS" from zwww_auth.t_syslog@auth;