Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> snapshot database link

snapshot database link

From: gorain pascal <pgorain_at_teaser.fr>
Date: 25 Mar 1999 07:19:28 GMT
Message-ID: <7dco20$igu@phenixgp.gp.fr>


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 !!!!

--

Received on Thu Mar 25 1999 - 01:19:28 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US