Re: What DBMS jobs and database links required for Materialized view replication?

Edwinah63 wrote:

What version of Oracle?

My first thought is I'd rather have a paper cut than use materialized
view replication. If in 9i or 10g look into using Streams or Change
Data Capture.
--
Daniel A. Morgan
University of Washington
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
.

Relevant Pages

  • Re: Combining snapclones with DataGuard
    ... am using snapclones, how can I also use DataGuard? ... Oracle Ace Director & Instructor ... Let me provide some lost information: The OS is Windows 2003 64-Bit. ... say that array-based replication "Works best in conjunction with Data ...
    (comp.databases.oracle.server)
  • Re: Hardware Replication vs DataGuard
    ... > volumes at a block level to a remote instance of Oracle? ... duplicate database was created in minutes. ... replacement for standby, it's a supplement. ... On the other hand, if you want to use the remote replication, I'm not sure ...
    (comp.databases.oracle.server)
  • Re: Combining snapclones with DataGuard
    ... Something Snapcloning can not guarantee as snapping will ... efficiently replicate corrupt blocks. ... Oracle Ace Director & Instructor ... say that array-based replication "Works best in conjunction with Data ...
    (comp.databases.oracle.server)
  • Re: Oracle Streams - worth it?
    ... We are evaluating different ways for a one-way replication from one database to another. ... pat of replicated data (detail rows only) should be updateable. ... an asyncronous job goes through the queue and pulls detail rows via database link. ... One of the possibilities we're looking at is Oracle Streams, but I have heard some allegations that it is inherently slow because it uses AQ as transport mechanism. ...
    (comp.databases.oracle.misc)
  • Re: Replication in databases
    ... How can we do this in Oracle? ... Multi-master replication is obsolete and has been replaced by ... far superior technology: Data Guard and Streams. ...
    (comp.databases.oracle.server)