鏁版嵁搴撳熀纭€锛氭暀浣犺交鏉炬帉鎻℃暟鎹簱閾捐矾鐨勫缓绔嬪拰浣跨敤

涓€銆佹暟鎹簱閾捐矾鐨勫缓绔嬶細

銆€銆€1銆佹暟鎹簱閾捐矾鐨勫缓绔嬭娉曚竴鑸槸锛欳REATE DATABASE LINK [db_link_name] CONNECT TO
銆€銆€[user_name] IDENTIFIED BY [password] USING '[tns_name]';

銆€銆€鍏朵腑:

銆€銆€[DB_LINK_NAME]锛氭槸鎵€瑕佽繛鎺ョ殑鏁版嵁搴撶殑鏈嶅姟鍚嶏紝涔熷氨鏄鏁版嵁搴撶殑鐪熷疄鍚嶇О(閫氬父灏辨槸SID)銆?br>銆€銆€[USRE_NAME]锛氭槸鎵€瑕佽繛鎺ョ殑鐢ㄦ埛鍚嶇О銆?br>銆€銆€[PASSWORD]锛氭槸鎵€瑕佽繛鎺ョ殑鐢ㄦ埛鐨勫瘑鐮併€?br>銆€銆€[TNS_NAME]锛氭槸鎵€瑕佽繛鎺ョ殑鏁版嵁搴撶殑鏈嶅姟鍛藉悕锛屼篃灏辨槸鍦ㄦ湰鏈轰笂寤虹珛鐨凬ET8鏈嶅姟鍛藉悕銆?/p>

銆€銆€2銆佸綋浣跨敤褰撳墠鐢ㄦ埛鍋氫负杩炴帴鑰呮椂锛岃娉曞彲浠ユ槸锛欳REATE DATABASE LINK [db_link_name] CONNECT TO CURRENT_USER USING '[tns_name]' (鏌愪簺鎯呭喌涓嬭繖绉嶆柟娉曞缓绔嬬殑鏁版嵁搴撻摼璺兘鏈浜庢椿鍔ㄧ姸鎬侊紝涓嶇煡閬撴槸涓嶆槸璇硶鏈夎锛屾殏涓嶆帹鑽愪娇鐢?銆?/p>

銆€銆€3銆佸綋浣跨敤宸茶繛鎺ョ敤鎴峰仛涓鸿繛鎺ヨ€呮椂锛岃娉曞彲浠ユ槸锛欳REATE DATABASE LINK [db_link_name]
銆€銆€USING '[tns_name]' 銆?/p>

銆€銆€4銆佽寤虹珛鍏叡鐨勬暟鎹簱閾捐矾璇硶鍙互鏄細鍙鍦–REATE鍚庡姞PUBLIC鍏抽敭瀛楀氨鍙互浜嗐€?/p>

銆€銆€5銆佸亣濡備綘鍦╥nit.ora鏂囦欢閲岀殑global_names = true鍙兘鐢ㄤ笂闈㈢殑鏂规硶锛屽鏋済lobal_names =false锛孾DB_LINK_NAME]涓嶄竴瀹氳鏄暟鎹簱鐨勭湡瀹炲悕绉帮紝鍙互鏄竴涓殢鎰忕殑鍚嶅瓧銆備篃灏辨槸璇达紝褰揼lobal_names = true鏃讹紝鏁版嵁搴撶殑姣忎竴涓敤鎴峰彧鑳芥湁涓€涓暟鎹簱閾捐矾锛岃€屽綋global_names = false鏃讹紝姣忎竴涓敤鎴烽兘鍙互寤虹珛N澶氫釜閾捐矾锛屼絾涓€鑸儏鍐典笅鏄病鏈夋剰涔夌殑銆?/p>

銆€銆€浜屻€佹暟鎹簱閾捐矾鐨勪娇鐢細

銆€銆€1銆佹暟鎹簱閾捐矾鐨勪富瑕佺敤閫斿氨鏄疄鐜板杩滅▼鏁版嵁搴撶殑璁块棶锛屼綘鍙互閫氳繃鏁版嵁搴撻摼璺洿鎺ュ杩滅▼鏁版嵁搴?/p>

銆€銆€鐨勮〃杩涜璇诲啓锛屼篃鍙互鍦ㄦ湰鍦板缓绔嬭繙绋嬫暟鎹簱鐨勮鍥惧拰鍚屾剰璇嶏紝鍙﹀鍦ㄨ繘琛屽弻鏈虹儹澶囦唤鏃朵篃瑕佺敤鍒版暟鎹簱閾捐矾銆?/p>

銆€銆€2銆佺洿鎺ヨ闂細SELECT * FROM [user_name].[table_name]@[db_link_name];INSERT锛孶PDATE锛孌ELETE绛変篃鍚屾牱閫傜敤銆?/p>

銆€銆€3銆佸缓绔嬪悓涔夎瘝锛欳REATE SYNONYM [user_name].[synonym_name] FOR [user_name].[table_name]@
銆€銆€[db_link_name] ; 瑙嗗浘涔熸槸涓€涓亾鐞嗐€?/p>

銆€銆€4銆佺敱浜庡弻鏈虹儹澶囨槸鍙︿竴涓鏉傜殑闂锛屾湰鏂囨殏涓嶈禈杩般€傚鏋滄兂鍦ㄤ袱涓暟鎹簱闂村疄鐜板嚑涓〃鐨勫悓姝ワ紝鍋氫竴涓弻鏈哄お澶嶆潅锛屽彲浠ヨ€冭檻鐢ㄨЕ鍙戝櫒鏉ヨВ鍐筹紝鍦ㄨЕ鍙戝櫒涓敤浠ヤ笂鏂规硶寮曠敤杩滅▼琛紝瀵瑰叾杩涜鎻掑叆锛屽垹闄や篃鍙互鍋氬埌鍚屾銆?/p>

銆€銆€鍙傝€冪ず渚嬪涓嬶細

銆€銆€鏁版嵁搴撲箣闂寸殑閾炬帴寤虹珛鍦―ATABASE LINK涓娿€傝鍒涘缓涓€涓狣B LINK锛屽繀椤诲厛鍦ㄦ瘡涓暟鎹簱鏈嶅姟鍣ㄤ笂璁剧疆閾炬帴瀛楃涓层€?/p>

銆€銆€1銆侀摼鎺ュ瓧绗︿覆鍗虫湇鍔″悕锛岄鍏堝湪鏈湴閰嶇疆涓€涓湇鍔″悕锛屽湴鍧€鎸囧悜杩滅▼鐨勬暟鎹簱鍦板潃锛屾湇鍔″悕鍙栦负灏嗘潵浣犺浣跨敤鐨勬暟鎹簱閾惧悕锛?/p>

銆€銆€2銆佸垱寤烘暟鎹簱閾炬帴锛?/p>

銆€銆€杩涘叆绯荤粺绠＄悊鍛楽QL>鎿嶄綔绗︿笅锛岃繍琛屽懡浠わ細

銆€銆€SQL>create public database link beijing connect to scott identified by tiger using 'tobeijing';

銆€銆€鍒欏垱寤轰簡涓€涓互scott鐢ㄦ埛鍜屽寳浜暟鎹簱鐨勯摼鎺eijing锛屾垜浠彲浠ユ煡璇㈠寳浜殑scott鏁版嵁:

銆€銆€SQL>select * from emp@beijing;

銆€銆€杩欐牱灏卞彲浠ユ妸娣卞湷鍜屽寳浜瑂cott鐢ㄦ埛鐨勬暟鎹仛鎴愪竴涓暣浣撴潵澶勭悊銆?br>