Oracle FAQ Your Portal to the Oracle Knowledge Grid

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle automatic routing possible with distributed databases (v8.1.7) ?

Re: Oracle automatic routing possible with distributed databases (v8.1.7) ?

From: Tony <>
Date: Wed, 17 Jul 2002 19:36:41 +1000
Message-ID: <f%aZ8.1$>

hi Nuno,

What you are saying is that if i have more than 2 sites, say Brisbane, Darwin etc ..
I would need to use the view and get the records. If the records are most of the time already available in the local database, will the latency (slowness) still be there, ie, if Site A has the record and i am running the transaction at Site A, will the view still have the latency since all the different locations are in that one View. Please excuse my ignorance. Not well verse in Oracle.

"Nuno Souto" <> wrote in message
> (tony) wrote in message
> >
> > Site A is in Sydney, Site B is in Melbourne. Site A only contains
> > Sydney related records and Site B contains only customer records local
> > to Melbourne. Both database table and field attributes are identical
> > except for the content.
> That would be dirt easy.
> >
> > Question: Is it possible to automatic get oracle to route from Site A
> > to Site B ? This is necessary when searching for a customer who
> > resides in Sydney but has come over to Site B (Melbourne) and needs to
> > access his/her record and make a on-line transaction of some kind.
> There is no "routing" at this level with Oracle. You can setup what is
> called a "database link" between both databases and create a view that
> looks at both tables (Sydney & Melbourne) as if they were one. From
> both sites. Dirt easy.
> However: If you plan to actually UPDATE the data, you should look
> carefully at the speed of that connection. The killer here is the
> reliability and speed of the connection between Melbourne & Sydney.
> Do not even DREAM of using modems or the like! You need at least
> a broadband connection for minimally acceptable performance.
> You may also look at replication:that is another avenue for this type
> of thing. Slower, but safer.
> Cheers
> Nuno Souto
Received on Wed Jul 17 2002 - 04:36:41 CDT

Original text of this message