Query on database link

From: magesh <magesh_at_garoo.ne.jp>
Date: Mon, 9 Oct 2000 14:07:21 +0900
Message-Id: <10643.118747@fatcity.com>

This is a multi-part message in MIME format.

------=_NextPart_000_000E_01C031FA.3DCFFDC0 Content-Type: text/plain;

        charset="iso-2022-jp"
Content-Transfer-Encoding: 7bit

Dear All

 I created a database link between 2 database . When i am try to access the table "emp" of scott scheme from the second database , getting an error like this ...

sql> select * from emp_at_orcl.kaiji1;

Error at line 1:
 ora-02085 :database links orcl.kaiji1 connects to orcl.world.

Why itz trying to connect to "orcl.world" instead of "orcl.kaiji1", How to resolve this problem ?

Details of 2 databases :-

first database(Source) ------------------------------------Second

database(destination)

db_name : ora8------------------------------------------------orcl
global_name:true----------------------------------------------true
db_domain:none-----------------------------------------------kaiji1

Received on Mon Oct 09 2000 - 00:07:21 CDT