Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create a public synonym for a db link - "Connection desccriptor not found".

user540159Jul 16 2010 — edited Jul 16 2010
I want to create a public synonym for a db link.
The existing db link name is tst.world ( which is in db links table and is working fine).

I created the following db link using the following command:

create public synonym "syn.world" for "tst.world";

It created the synonym successfully.
If I try the following, it throws error "Connection desccriptor not found".

select * from dual@syn.world;

It says "Connection desccriptor not found".

Any suggestions.

Thanks in Advance.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 13 2010
Added on Jul 16 2010
7 comments
1,628 views