Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Help needed with database links
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
![]() |
![]() |