[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)))';