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

On Mar 1, 8:05 am, "Tarby777" <tarbs..._at_yahoo.com> wrote:
> 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

my first impression seems to be you are using the wrong tool for those customers. Looks like they might be better off with a file sent weekly applied thru sqlloader. What are the business requirements?

  Ed Received on Thu Mar 01 2007 - 12:41:11 CST