Re: Database links question

Sorry for my confusion here, but are you therefore stating that it's possible to set up a database link only between databases with the same name? Our situation is that we have two databases on the same domain, different names that need the link for Advanced Replication.

(ie. DB1.ops.blah.com

      DB2.ops.blah.com)

Thanks.

Sybrand Bakker wrote:

> No, this is not true. On the contrary, between two databases with the same
> name it's impossible, especially if both databases are in the same domain
> and global_names = true. I don't know better that this parameter must be
> true in order to be able to use advanced replication.
> You can have identical databases as long as they are in different (DNS)
> domains, eg prod.oracle.com and test.oracle.com.
>
> Hth,
>
> Sybrand Bakker, Oracle DBA
>
> Boo <Boo_at_yahoo.com> schreef in berichtnieuws 3941480B.5F7034D4_at_yahoo.com...
> > Running Oracle 8.0.6 on Solaris 2.7
> >
> > We have a couple of databases set up on two different servers and will
> > need to set up advanced replication between these two servers.
> > The two databases do have different database names, but the same
> > schemas.
> > I haven't been able to determine 100%, through the documentation,
> > whether it's possible to set up a database link, but my thoughts are
> > that
> > only between two databases with the same name is it possible.
> >
> > Can someone clarify?
> >
> > TIA
> >
Received on Fri Jun 09 2000 - 00:00:00 CDT