DB Link

来源：互联网发布：淘宝卖家怎样设置运费编辑：程序博客网时间：2024/06/02 13:30

------------------------------------------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;

0 0