Oracle & SQL Server & SQL An
-
编辑 删除
oracle 10g database link
為了利用oracle 10g 自建的網站後台管理平台,特作了個數據庫鏈接(dblink) 來連接到遠端的oracle 8i服務器進行管理.以下是試作步驟:[@more@]1. 在tnanames.ora中設定遠程服務器別名RST: RST =(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = REMOTEIP)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ORCL)))2. 進入管理員SQL>創建數據庫鏈接:CREATE PUBLIC DATABASE LINK rsrv CONNECT TO username IDENTIFIED BY userpass USING 'rst'3. 通過數據庫鏈接名查看遠程服務器數據庫數據SELECT COUNT(*) FROM TAB@RST
