Re: queue up changes

From: Vladimir M. Zakharychev <vladimir.zakharychev_at_gmail.com>
Date: 9 Aug 2006 09:54:20 -0700
Message-ID: <1155142460.685071.143190@i3g2000cwc.googlegroups.com>

mike7411_at_gmail.com wrote:
> Is there a way for Oracle to queue up changes to a materialized view
> and then only transmit those changes across a DB link once a day?
>
> It is important that it doesn't send the full tables.

Yes, that's what materialized view logs are for. You can schedule pushes the way you want, too. Read Advanced Replication guide for your release for details on materialized view replication, fast refresh and its requirements, and all the rest of the manual. :)

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Wed Aug 09 2006 - 11:54:20 CDT