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 -> Re: Help needed with database links

Re: Help needed with database links

From: Jan <jan_gerards_at_hotmail.com>
Date: Mon, 10 Jan 2000 18:26:34 +0100
Message-ID: <85d4p1$m2$1@weber.a2000.nl>


I have tried it, but now I get the next error: ORA-02082: a loopback database link must have a connection qualifier ????

thanks in advance,
Jan

david_g wrote in message <26f15c5e.a00a3318_at_usw-ex0106-048.remarq.com>...
>create database link mylinkname -
>connect to schemaname identified by schemapassword -
>using 'tnsnamesdbname'
>
>where tnsnamesdbname is the name of the database as is included in
>your tnsnames.ora file
>
>you can then try it out with
>select * from v$database_at_mylinkname;
Received on Mon Jan 10 2000 - 11:26:34 CST

Original text of this message

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