Oracle DBLink腳本

Oracle DBLink腳本

-- Drop existing database link
drop database link DBLink名稱;

-- Create database link
create database link  DBLink名稱
  connect to 遠(yuǎn)程數(shù)據(jù)庫用戶名 identified by 密碼-
 

  using '(DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 遠(yuǎn)程數(shù)據(jù)庫IP地址)(PORT = 數(shù)據(jù)庫端口號))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = 實例名)
     )
   )';

 例：

-- Drop existing database link
drop database link TEST_DBLINK;
-- Create database link
create database link TEST_DBLINK
  connect to test identified by test
  using '(DESCRIPTION =
     (ADDRESS_LIST =
       (ADDRESS = (PROTOCOL = TCP)(HOST = 111.111.111.111)(PORT = 1521))
     )
     (CONNECT_DATA =
       (SERVICE_NAME = test)
     )
   )';

服務(wù)器租用/服務(wù)器托管中國五強！虛擬主機域名注冊頂級提供商！15年品質(zhì)保障！--億恩科技[ENKJ.COM]