Database link problems

Ok, I've read what must be every metalink and google result now and I still don't quite understand.

I'm trying to create a database link from one database to another. GLOBAL_NAME on the source database is TRUE, and is FALSE on the destination database. I would think this should not be a problem. When I 'select * from global_name;' on the destination database I get DB2. Back on the source database I do "create database link DB2 using 'DB2';' But I can't even do a "select sysdate from dual@DB2;" on the source database unless I set global_name=FALSE on the source database too.

What am I doing wrong? I have the database link name on DB1 = global_name of DB2.

Is it not possible to make a database link between 2 databases if the GLOBAL_NAMES parameter is not identical on both?

_________________________________________________________________
Don?t just search. Find. Check out the new MSN Search! http://search.msn.click-url.com/go/onm00200636ave/direct/01/

--
http://www.freelists.org/webpage/oracle-l


Other related posts:

  • » Database link problems