Re: snapshot database link

The syntax is
Create database link link_name
connect to user identified by password using T:uname:SID' / 'service_name'
service_name is mentioned in tnsnames.ora.

Nilima

gorain pascal wrote:

> hi !!
>
> i have a problem with the dblink comamand,
>
> can you give me some pointer to good examples !!!
>
> 1) i can access each database with command like sqlplus
> toto/toto_at_service
>
> 2) i see that sqlplus connect to the other database
> but i can use a link..
>
> my command is like that
>
> create database link ""dbname.network-name.fr" using
> '"tnsservicename.network-name.fr"'
>
> note that i have a minus sign in the name .
>
> the link is created but its don't work when i want to do :
>
> select * from username.table@"tnsservicename.network-name.fr"
>
> the error message is :
>
> tns could not resolve service name
> or without ""
> the command is not finished
>
> or with only select * from username.table@"tnsservicename"
>
> bad description
>
> thank you !!!!
>
> --
>
> --------- gorain pascal --------------
> --------- pgorain_at_teaser.fr -------------
Received on Thu Mar 25 1999 - 14:25:06 CST