基于Oracle多库查询方法(分享)

$vi $ORACLE_HOME/network/admin/tnsnames.ora

MEDIADBLINK =
 (DESCRIPTION =
  (ADDRESS_LIST =
   (ADDRESS = (PROTOCOL = TCP)(HOST = 10.0.0.1)(PORT = 1521))
  )
  (CONNECT_DATA =
   (SERVICE_NAME = db)
  )
 )

 -- Create database link
 create database link MEDIADB
 connect to dbuser identified by password
 using 'MEDIADBLINK';

select * from table_name@MEDIADB ;

create synonym aaa for table_name@MEDIADB ;

 select * from aaa;

 drop synonym aaa;