Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: Ed Prochak <edprochak_at_gmail.com>
Date: 1 Mar 2007 10:41:11 -0800
Message-ID: <1172774471.061036.215180@h3g2000cwc.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US