can we create synonym for database links? if yes what is the syntax and procedure..
Printable View
can we create synonym for database links? if yes what is the syntax and procedure..
i tried before on 8i but unfortunately cannot.. donno on 9i or 10g can or not.
AFAIK you cannot have synonyms for dblinks.
Srini
since when you cannot have synonyms for db links?!
sorry guys my fault, gave a wrong dblinkname and tried, just now realised it.
pando, if i create a synonym for dblink then how do i specify my sql.
select * from xyz@synonynname
is the above stmt right?
Srini
keep waiting;
pando will try and answer you.
why can't you try ?
SQL> create public synonym dumbass for remote_schema.dumbass@db_link_name;
This way you are creating a synonym locally for the remote table that you are accessing through the db_link.
Get it?
:D
MH
Yea, This one will work.. Tried before as well...Quote:
Originally posted by Mr.Hanky
SQL> create public synonym dumbass for remote_schema.dumbass@db_link_name;
This way you are creating a synonym locally for the remote table that you are accessing through the db_link.
Get it?
:D
MH