Streams in 9i: controlling the moment when changes hit the target database

Home -> Community -> Usenet -> c.d.o.misc -> Streams in 9i: controlling the moment when changes hit the target database

From: Tarby777 <tarbster_at_yahoo.com>
Date: 1 Mar 2007 05:05:39 -0800
Message-ID: <1172754339.855919.189440@30g2000cwc.googlegroups.com>

Hi all,

I've got a simple one-table one-way streams setup working quite happily, using sample code from oracle-base.com. Any changes to the source database are applied instantly to the target database. Now, this is fine for some folks but there will be those who want to have this happen - say - once a week at a certain time instead.

Am I right to think that the way (or, at least, one way) to achieve this would be by running DBMS_APPLY_ADM.START_APPLY and DBMS_APPLY_ADM.STOP_APPLY? TIA
Tarby Received on Thu Mar 01 2007 - 07:05:39 CST