Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Strange database link behavior
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 Mon Dec 28 1998 - 15:04:50 CST