七郎's JavaBlog

今天為了從外網(wǎng)數(shù)據(jù)庫(kù)導(dǎo)入到內(nèi)網(wǎng)數(shù)據(jù)庫(kù),采用了dblink方式進(jìn)行.

    創(chuàng)建dblink分為兩個(gè)步驟:

   1.建立本地服務(wù)名

   2.-- Create database link
create database link TEST.US.ORACLE.COM
  connect to user identified by pwd
  using '(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = orcl)
    )
  )';

曾經(jīng)參考語(yǔ)句:

CREATE DATABASE LINK數(shù)據(jù)庫(kù)鏈接名CONNECT TO 用戶名 IDENTIFIED BY 密碼 USING ‘數(shù)據(jù)庫(kù)連接字符串’;

數(shù)據(jù)庫(kù)連接字符串可以用NET8 EASY CONFIG或者直接修改TNSNAMES.ORA里定義.

數(shù)據(jù)庫(kù)參數(shù)global_name=true時(shí)要求數(shù)據(jù)庫(kù)鏈接名稱跟遠(yuǎn)端數(shù)據(jù)庫(kù)名稱一樣

數(shù)據(jù)庫(kù)全局名稱可以用以下命令查出
SELECT * FROM GLOBAL_NAME;

查詢遠(yuǎn)端數(shù)據(jù)庫(kù)里的表
SELECT …… FROM 表名@數(shù)據(jù)庫(kù)鏈接名;

附帶說(shuō)下同義詞創(chuàng)建:

CREATE SYNONYM同義詞名FOR 表名;
CREATE SYNONYM同義詞名FOR 表名@數(shù)據(jù)庫(kù)鏈接名;