Re: Query on database link

--0-1927150952-971097292=:59999
Content-Type: text/plain; charset=us-ascii  

You must have global_names turned on. That requires the db link name to match the database name that you're connecting to. Either turn off global_names, or modify the link name and global name of the remote database to be the same.   magesh <magesh_at_garoo.ne.jp> wrote:

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