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 -> Re: Database link and global names

Re: Database link and global names

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 29 May 2002 01:23:36 +0200
Message-ID: <ufa3eqjdnmh2b2@corp.supernews.com>

"Martin Drautzburg" <martin.drautzburg_at_web.de> wrote in message news:87adqk2fpv.fsf_at_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.
>
>

Global database names can be changed quite easily alter database rename global_name to etc.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address
Received on Tue May 28 2002 - 18:23:36 CDT

Original text of this message

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