I am trying to verify something I was told and need some help. The
proposed application requires that Oracle databases be installed at
several geographically distributed sites. Each of these installations
will have some tables that are for local use only, and other tables
that must be shared with the all other installations. The rate of
update for the shared tables is low, so I have been told that these
tables could be "mirrored" and that Oracle will automatically keep
them synchronized across all installations.

*** Is this true?
*** What related topics do I need to understand?

Thanks,
John Cooney

<jmc@webname.com> wrote in message
news:1121191820.452785.319720@g49g2000cwa.googlegr oups.com...
>I am trying to verify something I was told and need some help. The
> proposed application requires that Oracle databases be installed at
> several geographically distributed sites. Each of these installations
> will have some tables that are for local use only, and other tables
> that must be shared with the all other installations. The rate of
> update for the shared tables is low, so I have been told that these
> tables could be "mirrored" and that Oracle will automatically keep
> them synchronized across all installations.
>
> *** Is this true?
> *** What related topics do I need to understand?
>
> Thanks,
> John Cooney
>

You are probably referring to what's called "Replication".
Can also be done with Oracle Streams.
Check out the Oracle docs : http://tahiti.oracle.com

HTH
Matthias

I checked it out and found what I needed - Thanks for your help!

Matthias Hoys wrote:

> You are probably referring to what's called "Replication".
> Can also be done with Oracle Streams.
> Check out the Oracle docs : http://tahiti.oracle.com
>
> HTH
> Matthias