Hi,
i have requirement, to create a dblink, then i have to create a synonym on it.
Ex:
CREATE DATABASE LINK "xyz.abc.COM@asdf"
CONNECT TO "user1" IDENTIFIED BY VALUES ':1'
USING 'xyz.abc.COM';
I can get the data from using above db link.
select * from table1@xyz.abc.COM@asdf;
But after creating dblink, how to create a synonym on it, and how to select data from that synonym.