SQL> select * from dba_db_links;
OWNER DB_LINK USERNAME HOST CREATED
------------------------------ ----------------------- ------------------------------ --------------- ---------
PUBLIC ORCL.WORLD SCOTT ORCL 09-APR-14
JAMES ORCL.WORLD SNWADMIN ORCL 16-JAN-14
My question is every user in this database is able to access ORCL.WORLD db_link, as its owned by Public. However, when user James tries to access this DB_link, it connects him to his own private db_link, because both Public and Private db_link have same name.
What is the workaround for james , in case he wants to connect to public db_link ORCL.WORLD, as the public db_link is conencting to a different schema on ORCL database?