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) ?
A db-link can be set up so that Sites A and B can see each other's tables very easily.
should have A96580-01 the net services administrators guide.
"tony" <giaptt_at_yahoo.com.au> wrote in message
news:209eb63e.0207160027.7bce538f_at_posting.google.com...
> hi,
>
> Would it be possible to setup distributed database to do the
> following:
>
> 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.
>
> 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.
Received on Tue Jul 16 2002 - 04:51:35 CDT