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?




MH
Yea, This one will work.. Tried before as well...