Oracle Streams
From: Peter Barnett <regdba_at_yahoo.com>
Date: Fri, 3 Feb 2012 07:48:39 -0800 (PST)
Message-ID: <1328284119.61850.YahooMailNeo_at_web112915.mail.gq1.yahoo.com>
We are looking at keeping a remote database at a vendor site updated. �Timing is not terribly critical since one of the options is running a batch ETL job on a daily basis. �
Date: Fri, 3 Feb 2012 07:48:39 -0800 (PST)
Message-ID: <1328284119.61850.YahooMailNeo_at_web112915.mail.gq1.yahoo.com>
We are looking at keeping a remote database at a vendor site updated. �Timing is not terribly critical since one of the options is running a batch ETL job on a daily basis. �
Another option is to use Oracle Streams. �Our previous experience with this product has not been very positive but that has been several years ago. �It was high maintenance for the DBA and we had a problem on the target server maintaining RI without disabling a lot of triggers.�
Given the choices, has Streams improved enough to reconsider it?
�
Pete Barnett�
Database Technologies Lead�
Cambia Health Solutions
peter.barnett_at_cambiahealth.com
-- http://www.freelists.org/webpage/oracle-lReceived on Fri Feb 03 2012 - 09:48:39 CST