how to connect to two databases of oracle using dblink
- by KASHIFAMAN
i am tring to use db link for that i have first change the name of both databases to sol1(remote) and sol3(local) then i create a db-link
on sol3
CREATE DATABASE LINK SOL1.SWORLD
CONNECT TO TEST IDENTIFIED BY TEST USING SOL1;
LINK CREATED
ON SQL / SELECT * FROM CAT@SOL1.WORLD
MASSAGE
SQL COULD NOT RESOLVE THE SERVICE NAME
THEN I DROP THE…
