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!

ORA-12154: TNS:could not resolve the connect identifier specified

user12158503Mar 24 2010 — edited Mar 24 2010

Hi,
I created a new database called test_db and craeted a databaselink to database progdb. But when I try to query the table prospects in progdb using this database link, it gives me an error. Can someone please tell me where I am wrong?

CREATE DATABASE LINK progdb
CONNECT TO uatuser IDENTIFIED BY ****
USING 'progdb';

select * from prospects@progdb

ORA-12154: TNS:could not resolve the connect identifier specified

This post has been answered by EdStevens on Mar 24 2010

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 21 2010

Added on Mar 24 2010

#general-database-discussions

10 comments

1,724 views