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

giaptt_at_yahoo.com.au (tony) wrote in message news:<209eb63e.0207160027.7bce538f_at_posting.google.com>...
>
> 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
nsouto_at_optushome.com.au Received on Tue Jul 16 2002 - 19:14:05 CDT