Re: Table-level replication

From: Uwe Plonus <spam_at_sw4j.de>
Date: Thu, 15 Feb 2007 13:40:29 +0100
Message-ID: <er1kev$n3s$1@online.de>

Tarby777 wrote:
> Hi all,
>
> Some, not all, of the tables in my schema contain component library
> data. In a multi-site deployment, I want to have one site designated
> as the master and be able to propogate all the changes that take place
> in the master's component library to other sites, without messing with
> whatever non-component related data they may have. It's possible - but
> not guaranteed - that the remote sites will be able to "see" the
> master over the network (so near-instant replication isn't necessarily
> a requirement). They could be running any version of 9i and/or 10g.
> How can this be achieved?
>
> TIA
> Tarby
>

Hi,

have you looked for materialized views in Oracle? Materialized Views offer the possibility to replicate data even over the network.

Look for Materialized Views (or Snapshots) in google and in the oracle documentation and you will find a solution.

Uwe Received on Thu Feb 15 2007 - 06:40:29 CST