Re: snapshot database link

Try
select * from from username.table@"dbname.network-name.fr";

hth

Oliver

On 25 Mar 1999 07:19:28 GMT,
 pgorain_at_teaser.fr (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:04:04 CST