On Wed, Jul 7, 2010 at 4:58 PM, John Thompson <jhthomp@xxxxxxxxx> wrote: > We faced almost the exact dilema but had a shorter downtime window of 6 > hrs. Because of that, we had to use streams. Using this method, downtime > was less than 30 mins. during the switchover. > Hi, Streams has one potential disadvantage - if you are doing a huge updates on table it will be converted into number of row by row changes so replication time will be impacted. This same issue appear in Logical Standby too. regards, -- Marcin Przepiorowski http://oracleprof.blogspot.com -- //www.freelists.org/webpage/oracle-l