Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Database link and global names
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