| database link [message #61361] |
Sat, 17 April 2004 00:18  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
hi
i am having 2 databases and i want to have a replication with help of materialised views and i have created database link between 2 databases.
but when i tried to execute a query to read the data from another database by specifying the link name in statement
it's displaying error
'CONNECTION DESCRIPTOR NOT FOUND ...'
i have created database link successfully by specifying everything in a command
so anyone can help me how to resolve this
advance thanks
dilip
|
|
|
|
| Re: database link [message #61367 is a reply to message #61361] |
Sat, 17 April 2004 06:30  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
Do a "select * from ALL_DB_LINKS;", and ensure that
your DB_LINK, USERNAME and HOST values are correctly
specified. Also ensure that your HOST value is listed
in your TNSNAMES.ORA file and that you can "tnsping" it.
If everything appears to be correct, please post your
output here so we can look into it.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
