Re: Understanding "mirrored" tables

From: Matthias Hoys <idmwarpzone_NOSPAM__at_yahoo.com>
Date: Tue, 12 Jul 2005 21:16:50 +0200
Message-ID: <42d41723$0$24386$ba620e4c@news.skynet.be>

<jmc_at_webname.com> wrote in message
news:1121191820.452785.319720_at_g49g2000cwa.googlegroups.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 Received on Tue Jul 12 2005 - 14:16:50 CDT