关于oracle数据库(远程对象调用)

最新推荐文章于 2021-04-15 19:10:22 发布

iteye_1532

最新推荐文章于 2021-04-15 19:10:22 发布

阅读量255

点赞数

分类专栏：编程经验文章标签： Oracle

编程经验专栏收录该内容

23 篇文章 0 订阅

订阅专栏

[img]http://jiaoxujin.iteye.com/upload/picture/pic/11851/68e4ac3e-bd38-3f61-997a-2faa553e2403.jpg[/img]
[img]http://jiaoxujin.iteye.com/upload/picture/pic/11853/e56ffcad-1427-3e1a-b334-6ca096eca039.jpg[/img]
[img]http://jiaoxujin.iteye.com/upload/picture/pic/11855/f391fc30-d6f3-3526-90a0-4313bf5272eb.jpg[/img]
[img]http://jiaoxujin.iteye.com/upload/picture/pic/11857/b3475737-c745-360b-9a9c-33a31169d25c.jpg[/img]
-- Drop existing database link
drop database link DASH.US.ORACLE.COM;
-- Create database link
create database link DASH.US.ORACLE.COM
connect to WGR_QRY identified by WGR_QRY_123
using '(DESCRIPTION =(ADDRESS_LIST =(ADDRESS =(PROTOCOL = TCP)(HOST = schop147.sch.ge.com)(PORT=1521)))
(CONNECT_DATA=(SID=schop147)(SERVER = DEDICATED)))';