Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Synchronizing 2 tables in same database -how ?
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
![]() |
![]() |