Re: about databse link

From: Alan Shein <alanshein_at_erols.com>
Date: Tue, 9 Nov 1999 10:28:12 -0500
Message-ID: <809eh1$amu$1@autumn.news.rcn.net>

The database link name needs to be the same name as the database you are connecing to, so in this case, it appears that the link name needs to be ORCL.WORLD. This will probably cause a problem because all of your db_names are probably ORCL. The way around this is to do an

ALTER DATABASE RENAME GLOBAL_NAME TO orlc2.world (<--for example) on the database you want to connect _to_, then re-create your link using this new global name. Be sure to maintain the .world qualifier at all times. SO, you would eventually wind up with a database link named "orcl2" instead of "remote_connect".

frank chien <chien2_at_ms5.hinet.net> wrote in message news:942107890.559814_at_m5.pagic.net...
> Dear all,
>
> I use Oracle 8.0.5 on linux.
> Now I want to use synonyms between two
> Oracle servers.
> When I create database link, it is success.
> But when I select data from remote machine.
> It show the message:
> database link REMOTE_CONNECT.WORLD connects to ORCL.WORLD
> what should I do?
>
> Frank Chien
>
>
Received on Tue Nov 09 1999 - 09:28:12 CST