| dblink problem [message #214873] |
Thu, 18 January 2007 05:38  |
mehulmb
Messages: 25
Registered: May 2006
Location: Pune
|
Junior Member |
|
|
i want to create dblink between two database which are reside in unix os. now i have tried to create on dblink in my window-xp base system like below :
create PUBLIC database link cmc
connect to depot identified by depot
using 'cmc';
and it's created sucessfully but problem is arrived when i tried to make select statement like this :
select * from mgm_master@cmc;
it will display error like this :
ORA-12154: TNS:could not resolve the connect identifier specified
i already check my tnsnames.ora file properly but i cann't understand why should this error display me again and again. plz give me solution about it...
thanks in advance...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
