golden gate and partition exchanges

From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Mon, 27 Jun 2011 10:04:58 -0400
Message-ID: <BANLkTimZC-hmu_r843cPcs3pUZk2zWhauw_at_mail.gmail.com>

database 10.2.0.5
OS: hp unix
Targets: another database on hp-unix and teradata

Here are a couple of scenarios. How would golden gate handle this? and if there are problems how would I handle it.

1. I have a parent table that is partitioned by day. This parent table is replicated with golden gate to both targets. I exchange the partition to the history table every night. The history table is not replicated.
2. I have a parent and a history table replicated by golden gate. The parent and child table are partitioned by day. Every a partition is exchanged to the history table.
3. I have a history table that is partitioned by day. This table is replicated by golden gate. Every night a partitioned is exchanged to this table that is from a table that is not replicate

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Jun 27 2011 - 09:04:58 CDT