------------------------------------------DB link---------------------------------------
alter system set global_names=true;
这个要求创建的dblink名称要和实例名一致,会报下面这个错
Error: ORA-04052: 在查找远程对象 GS1BLL2.BLL_CHARGE_201307@DBLINK_BILLINGDB 时出错
ORA-00604: 递归 SQL 级别 1 出现错误
ORA-12545: 因目标主机或对象不存在, 连接失败
--------------------------------------------------------------------------------------
(1)删除db link
drop database link to_peng;
(2)创建DB link
create /*public*/ database
link topeng /*(DB link的名字)*/
connect to topeng /*(目标数据库的用户名)*/
identified by topeng /*(目标数据库用户的密码)*/
using 'crmdb' /*(SID)*/;
create database link db_link_cbs_rpt
connect to db_link_cbs_rpt
identified by cbs_rpt
using
'(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.203)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = dwhora)
)
)';
(2)授予create database link权限
GRANT CREATE DATABASE LINK TO lbikr_babilon
(3)回收create database link权限
revoke CREATE DATABASE LINK from lbikr_babilon;