Re: advanced replication

Michael Fontana wrote:

>>You're saying materialized views should no longer be used? I think
>

[...]
>
> PS - Some of the newer tools, such as Streams and readonly-standby,[...]

As noted, both basic and advanced replication use mviews, but "advanced"   added the multi-master feature.

To the OP: a fast-refresh capable MV only pushes the incremental changes.

Even better than read-only physical standby is logical standby. Uses the same technology as Streams (SQL Apply) but is easier to set up at the database level. If you just want to replicate a few objects, use Streams; if you want to replicate entire schemas or database, use Logical Standby.

-- 
Mark Bole
http://www.bincomputing.com



--
http://www.freelists.org/webpage/oracle-l