Re: database link

Hi Man,

if you are trying connect xxx/pwd_at_sid(service), you didn't create db_link successfully!
Because you are connect a remote DB by TNS not the db_link!(got it?) You didn't create the"@mine"'s tnsname in the tnsname.ora, so that you should meet the error: TNS error could not resolve tns name mine.
If you create the"@mine"'s tnsname in the tnsname.ora,you should avoid the tns error!

Lawrence
02/23/2001

On Mon, 19 Feb 2001 17:22:03 +0100, christophe <chhember_at_euriware.fr> wrote:

>hi,
>i created a database link from a database called ox4i to a remote base
>called mgv8 on two different hosts.
>i used the command: create database link mine connect to login
>identified by password using 'mgv_service'
>the link was created and i am able to connect on mgv8 with the command :
>connect login/password_at_mgv_service
>so mgv_service is available
>but as i tried to read a table in mgv8 from ox4i using the command:
>select * from table1_at_mine,
>i got the error: TNS error could not resolve tns name mine.
>
>could someone help me?
>
Received on Fri Feb 23 2001 - 00:45:37 CST