Re: Living replicas

> I am afraid of the gotchas and would like to hear if anyone here has
> gathered any experience with Oracle Streams.

Streams does probably have the same issues as LogMiner does, that means not supporting some datatypes for replication (object datatypes for example, IIRC). Also, nologging data loads contents will not be stored in any log.

One more way to do this kind of incremental migration would be using triggers on all your tables, which save all changes to alternate tables (or use snapshot/mv logs). Then you can apply the contents of alternate tables to production when original data is transferred there (each table has an additional column stating which type of DML operation is associated with given row).

OTOH, this puts some additional load on your system and you have to plan/test the operations quite carefully, for example, how will you do the initial copy, that when applying transaction logs, you wouldn't have gaps or duplicate data...

Tanel. Received on Sat Jan 17 2004 - 07:44:09 CST