Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Strange database link behavior
I think your link name has to correspond to the name in the tnsnames.ora
file.
Will Hartung wrote in message ...
>I'm trying to create a database link between two servers.
>
>I've executed the following command:
>
>create public database link serverb connect to username by password using
>'serverb';
>
>In the USING clause, I'm entering the service name.
>
>However, when I try to do something like:
>
>select * from table_at_serverb
>
>I get a:
>
>ORA-02085: database link SERVERB.WORLD connects to BALAK.WORLD
>
>The error messages manual says that the link name must be the same as the
>database name. But I *THINK* that's what I'm doing.
>
>Any advice would be appreciated.
>
>
>
>
Received on Wed Dec 30 1998 - 02:31:05 CST