这里所需要的信息: 从MM库向GG库建立dblink
- select *from global_name;
- -- Create database link
- create database link MMDB.GGDB.QHLIFE.COM --dblink的名称,一般是两个库的global_name,和公司的域名
- connect to GGN identified by "ggk" --需要连接库的用户名,密码,密码带双引号区分大小写
- using '(DESCRIPTION = --需要连接库的TNS信息
- (ADDRESS = (PROTOCOL = TCP)(HOST = 10.50.64.187)(PORT = 1521))
- (CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = zjuat))
- )';
- select *from dual@MMDB.GGDB.QHLIFE.COM;
- drop database link MMDB.GGDB.QHLIFE.COM;
- create synonym GGTABLE for GGDB_TABLE@MMDB.GGDB.QHLIFE.COM;