Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Database link and global names

Database link and global names

From: Martin Drautzburg <martin.drautzburg_at_web.de>
Date: 28 May 2002 22:13:32 +0200
Message-ID: <87adqk2fpv.fsf@web.de>


After a migration from 8.0.5 to 8.1.7 we ran into the following problem:

On the database "foo.world" there used to be a database link "bar" pointing to a database "bar". Global names had been set to true because we used advanced replication.

        foo.world -bar-----> bar

After the migration the "bar" database link magically appeared as
"bar.world". Now I have a link named "bar.world" pointing to a
database named "bar". This does not work with global names = true.

        foo.world -bar.world--> bar

Neither me nor oracle support could figure out be how to establish a database link from a database "with a domainname" to a database
"without a domainname" when global names = true.

Of course I could rename bar to bar.world, but this this database is not under our control and the guys there will claim that nothing has changed on their side.

I might also change foo.world to foo, but this is a node in a replicated environment and I'd have to change dozens of database names or *they* would run into a global names problem.

For any help on this issue I'd be most grateful. Received on Tue May 28 2002 - 15:13:32 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US