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

Home -> Community -> Usenet -> c.d.o.server -> Re: Synchronizing 2 tables in same database -how ?

Re: Synchronizing 2 tables in same database -how ?

From: Doron <doron_almog_at_msn.com>
Date: 21 Nov 2003 06:25:12 -0800
Message-ID: <995517bc.0311210625.6de592d2@posting.google.com>


hi,
assuming that the batch job is committing on a frequent basis. a fast refresh with the on commit option shouldent create a large log. this seems to be a classic example for a materialized view. after all this we are talking about the same thing replication of data.
with the materilized view option you are letting oracle do all the configuring while when creating a replicated table you are doing all the configuration. Received on Fri Nov 21 2003 - 08:25:12 CST

Original text of this message

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