《数据库DbLink配置文档》由会员分享,可在线阅读,更多相关《数据库DbLink配置文档(2页珍藏版)》请在金锄头文库上搜索。
1、数据库DBLINK配置文档1配置的2个数据库都在一个机器上。于 PL/SQL Developer - IDEO_IOHITORSORCL - SQL 窗口一 using禺文件世工程 编辑 会话 调试 工具(T)宏 文档W 报告B BM %fir*E4Loe = M21My objectsVSQL输出统计表usiJig 11 (DESCRIETION = (ADDBESS_LIST =棉_l摄近对象回收站_| Functions_| Procedures_| Packages_| Package bodies_| Types_| Type bodies_| Triggers_| Java sou
2、rces_| Jobs_| Queues_| Queue tables_| Libraries_| Directories_| T ables_| Views_| Materialized views_| Sequenu亡w_| Users_| Profiles_| Roles_| SynonymsJ Database linKs皆 DBLINK1.REGRESS.RDBk 皆 dg.regress.rdbms.de 皆 JZKFLEOPARD.REGRESS 皆 SSH.REGRESS.RDBMS.DI 皆 SMMS.REGRESS.RDBMS. T ablespacesClusters新泮
3、create database link Z-BLINKL. RE GRESS . RZconnect to DGYIusing 1 DE SCRIFTION = (ALDRES5_LIST = :select * from sy_u3e r1inkfwqUSER CODEORG CODEUSEF1yyshengOI-A011220-殷超2yuhjiao-A011226-于红93yuarijMid-A011212-袁金乍4yua nuhlA011207-袁乘75yiingyu-A011224-于敬6yjfandlMm-A011202-杨继电1yehmei-A011230-叶红卡0yaoth-A
4、011210-姚同为9yanubiao-A011215-阎玉卫10yangsm-A011214-畅子:11yangzhfeng-A011216-杨照111 1 f c rA Fi-I -1 91 匚iim707 M 选择,耗时1.4関秒凶昌 ABC 03= 帕数据库连接连接的名字连接到目标数据库SSID2.2个数据库不在同一个机器上。例如:192.168.0.23机器上有个数据库 用户名和密码:dgyt数据库SSID: orcl执行连接语句:create /* public */ database link dblinklconnect to dgyt identified by dgytusing (DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = 192.168.0.23)(PORT = 1521)(CONNECT_DATA =(SERVICE_NAME = orcl);注意:using后面的必须在一行。如果有问题联系研发部视频监控组。